CODEWITHSUNDEEP
mysqllockinginnodb
davidbrai
davidbrai

Reputation: 1229

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

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?

Upvotes: 12

Views: 26283

Answers (2)

Shahid Hussain
Shahid Hussain

Reputation: 1789

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

Upvotes: 1

rkosegi
rkosegi

Reputation: 14668

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/

Upvotes: 10

Related Questions