Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I view real-time locks in innodb when information_schema.innodb_locks is not available?

share|improve this question
up vote 1 down vote accepted

The quick way to see it is to run SHOW ENGINE INNODB STATUS\G

You will see

  • exclusive locks
  • shared locks
  • corresponding queries
  • number of read IO thread in use
  • number of write IO thread in use

Here are some sample questions I answered that uses the output of SHOW ENGINE INNODB STATUS\G

Give it a Try !!!

share|improve this answer
Are these locks in the TRANSACTIONS section? – jersten Mar 19 '13 at 20:09
Please keep in mind that a single INSERT, UPDATE, or DELETE is itself a transaction when autocommit = 1 (which is the default. – RolandoMySQLDBA Mar 20 '13 at 0:50
Yes, I am referring to locks in the TRANSACTION sections. – RolandoMySQLDBA Mar 20 '13 at 0:51
Thank you, kind sir !!! – RolandoMySQLDBA Mar 26 '13 at 14:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.