Aug 06, 2014
 Percona MySQL Webinar
  Alexander Rubin

Access the webinar recording at: https://www.percona.com/resources/mysql-webinars/advanced-query-tuning-m...

Tuning MySQL queries and indexes can significantly increase the performance of your application. In this webinar, Percona Principal Architect Alexander Rubin discusses advanced techniques for optimizing MySQL queries, including new topics related to MySQL 5.6 and higher.

Topics include:

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


About the Author

Alexander Rubin

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.