Jan 07, 2016
Percona MySQL Webinar
Alexander Rubin, Janis Griffin
Too often developers and DBAs struggle to pinpoint the root cause of performance issues and then spend too much time in trying to fix them. Discover how you can significantly increase the performance of your applications while also reducing database response time. In this webinar, Principal Architect, Alexander Rubin and Database Evangelist, Janis Griffin will provide the key steps needed to identify, prioritize, and improve query performance. The following topics will be discussed:
- Wait time analytics using Performance / Information schemas
- Monitoring for performance utilizing DPA
- Explaining plan operations focusing on temporary tables and filesort
- Using indexes to optimize your queries
- Utilizing loose and tight index scans in MySQL
About the Authors

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.