Aikesheng Open Source Community
Mar 1, 2022 · Databases
Diagnosing MySQL Replication Lag Caused by Page Compression Using perf and pstack
The article explains how a MySQL 5.6 master‑slave setup experienced growing replication lag on an off‑site replica, how the issue was traced to page‑compression on a large table using show slave status, perf and pstack, and how disabling compression resolved the delay.
MySQLPerformanceReplication
0 likes · 4 min read