Aikesheng Open Source Community
Jul 13, 2021 · Databases
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