Using MySQL Performance Schema to debug performance issues

Database Administration
25 April 12:50pm - 13:40pm @ Ballroom A

Debugging MySQL performance issue is not easy. MySQL still lacks some crucial metrics to analyse and detect performance bottlenecks.
Many DBAs have to rely on sparse information available from server and OS or sometimes just a wild guess. Decisions made as a
result of such analysis are often wrong and result in further issues and frustration.
Performance Schema is a MySQL feature than allows users to look into great details of server internal state and potential
performance bottlenecks. This feature has been around for almost 2 years already but it is still not very widely used. This presentation
will show how one can use Performance Schema for real life analysis. It will cover cases where Performance Schema is a natural fit and also
describe scenarios where it doesn't work. Presentation will also mention what improvements MySQL 5.6 has in regard to Performance Schema.

This presentation will be of interest to anyone who deals with MySQL performance: DBAs, application developers, system admins.

Speakers

Zburivsky Danil
MySQL DBA & Team Lead, Pythian
Biography: 
Originally from Ukraine, Danil has been working with different RDBMS since his early years in university. He holds a Master's Degree in Applied Math at the Donetsk National University in Ukraine where he also worked as a database developer on an accounting system. Danil got his first taste for MySQL while working as a DBA for Sonopia Corp, where he participated in the database design and support for a social mobile network application. In his current role as Team Lead, he is helping people all over the world to solve problems with their MySQL systems for Pythian (www.pythian.com), a leading, global database and application infrastructure services company.

Slides