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.