Buy Percona SupportEmergency? Get 24/7 Help Now!
  Aug 06, 2014
  Percona MySQL Webinar
   Alexander Rubin

Advanced Query Tuning in MySQL 5.6 and Beyond

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
Alexander Rubin
Principal Consultant


General Inquiries

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