Buy Percona ServicesBuy Now!
  Wednesday, July 22, 2015
   Alexander Rubin

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
Alexander Rubin
Principal Consultant
Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.