Tuning queries and schema/indexes can significantly increase the performance of your application and decrease response times. Join Principal Architect Alexander Rubin as he gives an updated version of his ever-popular Advanced Query Tuning presentation. Alex will talk about new MySQL 5.6 and 5.7 algorithms that have been designed to improve query performance and simplify tuning. He¹ll also cover:
- Group by and order by optimizations
- MySQL temporary tables and filesort
- Using covered indexes to optimize your queries
- Loose and tight index scan in MySQL
- New MySQL 5.6 and 5.7 Optimizer features and improvements