Analyzing and Resolving MySQL Global Read‑Lock Deadlocks in Parallel Replication

The article investigates a MySQL 8.0.18 replication deadlock caused by numerous set global read_only commands, explains the lock‑waiting chain involving global read and commit locks, reproduces two deadlock scenarios, and proposes practical solutions such as killing offending sessions or disabling slave_preserve_commit_order.

deadlockglobal read lockperformance_schema

0 likes · 14 min read

Analyzing and Resolving MySQL Global Read‑Lock Deadlocks in Parallel Replication

Aikesheng Open Source Community

Sep 9, 2019 · Databases

How to Quickly Identify and Kill Sessions Holding Global Read Locks in MySQL

This article explains several practical techniques—including using the performance_schema.metadata_locks view, events_statements_history, a gdb script, and filtered SHOW PROCESSLIST queries—to locate and terminate the MySQL session that holds a global read lock, thereby restoring normal write operations.

global read lockmysqlperformance_schema

0 likes · 8 min read

How to Quickly Identify and Kill Sessions Holding Global Read Locks in MySQL