Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Exploring Percona XtraDB Cluster using Performance Schema

Exploring Percona XtraDB Cluster using Performance Schema

 5 October 3:10 PM - 3:35 PM @ Matterhorn 2
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Scalability/Performance
MySQL
Topics:
MySQL
Tools and Techniques
Monitoring

Description

Often it is important to track and understand Percona XtraDB Cluster operations while executing a workload. Log files are one of the ways to track this information. Unfortunately, their capability is limited unless the user plans to use wsrep_debug. This method, however, can be too verbose and difficult to understand for end-users. Performance Schema helps solve this problem. We can use performance schema to understand different objects/instruments being used by Percona XtraDB Cluster during the workload operation. Besides getting to know the flow and seeing the progress, it also helps to track operational delays due to rollback or replay. In addition, you can find out other objects such as files and threads that are created by Percona XtraDB Cluster. Some of these actions are dynamic and short-lived, so it helpful to also get this view of the system.

Speakers

Krunal Bauskar's picture

Krunal Bauskar

Software Engineer (PXC Lead), Percona

Biography:

Krunal joined Percona in September 2015. Before joining Percona he use to work as part of InnoDB team at MySQL/Oracle. He authored most of the temporary table revamp work besides lot of other features. In past he was associated with Yahoo! Labs researching on bigdata problems and database startup which is now part of Teradata. His interest mainly includes data-management at any scale and has been practicing it for more than decade now.

Share this talk


Slides