dbaplus Community
Jan 3, 2018 · Databases
Why Flush Tables with Read Lock Can Deadlock MySQL Replication and How to Fix It
The article analyzes a rare three‑thread deadlock caused by FLUSH TABLES WITH READ LOCK during parallel replication on MySQL 5.7, explains the MDL lock interactions, shows how to reproduce the issue, and provides practical kill‑thread and configuration solutions to avoid it.
MDL lockdeadlockflush tables
0 likes · 11 min read