A closer look at query optimization with a focus on queries with GROUP BY and ORDER BY, from Percona consultant Alexander Rubin.