<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=95128&amp;fmt=gif">

Advanced Query Tuning in MySQL 5.6 and 5.7


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