Advanced Query Tuning in MySQL 5.6 and Beyond

Topics include:

GROUP BY and ORDER BY optimization
MySQL temporary tables and filesort
Using covered indexes to optimize your queries
Utilizing new MySQL 5.6 algorithms:
Engine condition pushdown and MRR
Subquery materialization and semi-join
Geo/Spatial search

[jippi]

Quite frustrating that the slides and sound is not synced properly.... and that clicking going on all the time