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

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: [crayon-60122d2375032492365772/] The processlist state for the SQL thread can be one of the following:┬áReading … Continue reading Causes and Workarounds for Slave Performance Too Slow with Row-Based Events