How can I see global locks in mysql (innodb)?

Question

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?

Answer 1

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/

Answer 2

This is not a global lock.once you come out of session ,it releases it