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.