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.
DatabaseMySQLglobal read lock
0 likes · 8 min read