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


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 !!!

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy