The Ultimate Guide to MySQL Query Optimization
At its core, query optimization comes down to one goal: Make the database read as few rows as possible.
If MySQL reads 300,000 rows to return 5 results, it is slow. If it reads 5 rows to return 5 results, it is lightning fast.
In The Developer’s Guide to Identifying Slow MySQL Queries, we covered the mechanics of finding your slowest queries using server logs and gave a brief introduction to the EXPLAIN command.
But once you’ve identified a slow query,
... Continue reading
Posted in Coding, Server Admin & Security
Tagged boolean mode, composite indexes, covering index, deferred join, ESR, explain, explain analyze, fulltext, indexes, like vs fulltext, match against, mysql, mysql database, mysql query optimization, natural language mode, order by, RAM, slow mysql queries, where
Leave a comment