Buy Percona SupportEmergency? Get 24/7 Help Now!
  Wednesday, May 15, 2013

Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks

MySQL 5.6 offers substantial improvements to Performance Schema. This provides even more insight into how MySQL executes queries, allowing us to identify and troubleshoot bottlenecks. In this webinar, we will look at using MySQL 5.6 performance schema for performance diagnostics and troubleshooting typical workload bottleneck issues, such as:

• Bottlenecks with Disk IO
• Problems with excessive temporary tables and external sorts
• Excessive internal mutex contention
• Slow queries due to waits on InnoDB locks and Meta Data locks

Peter Zaitsev
Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. As one of the foremost experts on MySQL strategy and optimization, Peter leveraged both his technical vision and entrepreneurial skills to grow Percona from a two-person shop to one of the most respected open source companies in the business. With over 150 professionals in 20 plus countries, Peter’s venture now serves over 3000 customers – including the “who’s who” of internet giants, large enterprises and many exciting startups. Percona was named to the Inc. 5000 in 2013, 2014 and 2015. Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science. Peter is a co-author of High Performance MySQL: Optimization, Backups, and Replication, one of the most popular books on MySQL performance. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Data Performance Blog. He has also been tapped as a contributor to Fortune and DZone, and his recent ebook Practical MySQL Performance Optimization Volume 1 is one of’s most popular downloads. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.

General Inquiries

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