Community

MySQL Can’t Use Index With Uncorrelated IN Subquery

(Alex Gorbachev) Today is the first time I had to look at MySQL performance. Tiny database as web application back-end was having significant performance issues with spikes of CPU workload. After identifying problematic queries, I found a pile of statements using IN subqueries.

Read More - Register for Free Membership