Tuning MySQL queries and indexes can significantly increase the performance of your application and decrease response times. In this webinar, Percona Principal Consultant Alexander Rubin will discuss advanced techniques for optimizing MySQL queries. Topics include:
1. GROUP BY and ORDER BY optimization
2. MySQL temporary tables and filesort
3. Using covered indexes to optimize your queries
4. Loose and tight index scans in MySQL
About the Author
Alexander RubinAlexander 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.
Getting Additional Help
If you need help with MySQL query tuning, the Percona Consulting team can help you resolve even the most complex issues with a custom performance tuning engagement to address your challenges. In addition, a Percona MySQL Performance Audit can ensure your queries are tuned and your system is running optimally.
Contact us now for more information.