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.
This article explains the concept of deadlocks, outlines the four necessary conditions, and provides a step‑by‑step guide using pstack and gdb on Linux to identify, analyze, and fix thread deadlocks, along with practical prevention techniques.
This article explains the concept of deadlocks, outlines the four necessary conditions, and demonstrates a step‑by‑step Linux workflow using pstack and gdb together with a sample pthread program to identify, analyze, and fix cross‑locking deadlock scenarios.
A MySQL 5.5 server on CentOS 6.7 hung because two internal mutexes (LOCK_index and LOCK_thread_count) deadlocked during concurrent purge binlog and reset master commands, and the issue was resolved by upgrading to a version where the bug is fixed.
This article explains what a deadlock is, outlines its four necessary conditions, provides a sample pthread program that deadlocks, and shows step‑by‑step how to use pstack and gdb on Linux to identify the stuck threads and understand the root cause.
