How can I see global locks in mysql (innodb)?
21,693
Try this :
SHOW ENGINE INNODB STATUS;
It will show owner of locks and waiters (and lot of other stuff related to innodb)
http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html
http://www.xaprb.com/blog/2006/07/31/how-to-analyze-innodb-mysql-locks/
Author by
davidbrai
Updated on March 29, 2020Comments
-
davidbrai about 4 years
If in understand correctly, running
FLUSH TABLES WITH READ LOCK
acquires a global read lock.Is there any command I can run in the mysql client which shows me that lock is currently acquired?