Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

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? –  josten 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

 
discard

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.