INNODB real-time locks?

Question

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

score 0 · Accepted Answer · edited Apr 13 '17 at 12:42

0

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

You will see

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

Give it a Try !!!

edited Apr 13 '17 at 12:42

Community

answered Mar 19 '13 at 18:40

RolandoMySQLDBA

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 00:50
Yes, I am referring to locks in the TRANSACTION sections. – RolandoMySQLDBA Mar 20 '13 at 00:51

1 Answers1