Recently I worked on one customer issue that I would describe as slave performance too slow. During a quick analysis, Ive found that the replication slave SQL thread cannot keep up while processing row-based events from the masters binary log. For example: [crayon-5aef650f85662300585333/] The processlist state for the SQL thread can be one of the following: Reading [&]

The post Causes and Workarounds for Slave Performance Too Slow with Row-Based Events appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/slave-performance-too-slow-with-row-based-events-causes-and-workarounds/