Tired of MySQL Making You Wait?

 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.
 

Janis Griffin

Janis Griffin has over 25 years of DBA experience including design, development and implementations of many critical database applications. Before coming to SolarWinds over 8 years ago, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As an Oracle Ace, Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning.