Buy Percona ServicesBuy Now!

Causes and Workarounds for Slave Performance Too Slow with Row-Based Events

 | May 3, 2018 |  Posted In: High-availability, Insight for DBAs, MySQL, Replication

Slave Performance Too Slow

Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log. For example:

The processlist state for the SQL thread can be one of the following: Reading […]

Read More