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.


Zburivsky Danil
Big Data Consultant / Solutions Architect , Pythian
Danil Zburivsky, Big Data Consultant/Solutions Architect, Pythian. Danil has been working with databases and information systems since his early years in university, where he received a Master's Degree in Applied Math. Danil has 7 years of experience architecting, building and supporting large mission-critical data platforms using various flavours of MySQL, Hadoop and MongoDB. He is also the author of “Hadoop Cluster Deployment” book. Besides databases Danil is interested in functional programming, machine learning and rock climbing.