Using MySQL Performance Schema to debug performance issues

Доклад принят в Программу конференции
Максим Ванюшкин (Команда Тинькофф — это разработчики, продакт-менеджеры, дизайнеры, маркетологи, аналитики, тестировщики, SRE-инженеры и другие специалисты. Вместе они создают новые и развивают существующие финтех-продукты, которыми пользуются 25 миллионов клиентов и каждый из нас.)Максим Ванюшкин

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.