MySQL is the heart of most Drupal sites but few developers have had training in SQL and fewer less understand query tuning. This is an introduction to MySQL query tuning for those Drupal develoeprs too busy to dig deeply in the docs. It covers query plans, the optimizer, indexing, range scans, and how to tell when EXPLAIN is lying to you.

1. From SQL syntax to a query plan
--Syntax check
--Optimizer
--The 'plan'
2. Why did the optimizer pick that?
--Statistics
-- Index -- how they hurt, help, and mislead
--Why does it read the entire file when i need just the top 10?!?!
--Lies, damned lies, and your query
4. What to avoid and how to spot it
5. How ten minutes of work can save your Drupal instance hours a day performance wise