In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster.
Introduction
When you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes to the top of your mind. It is an effective way to track the thread status. We decided to improve the stages in Percona XtraDB Cluster to make “SHOW PROCESSLIST” more meaningful.
In the blog below, we will check out the different wsrep-stages and the significance associated with them.
Loading of data
Running a simple insert/sysbench prepare workload. The state is stable as it mainly captures …
[Read more]