Exploring Percona XtraDB Cluster using Performance Schema
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.
Software Engineer (PXC Lead), Percona
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.