InnoDB - How to get top locked tables and rows which are locked I was searching for a tool OR query which can give me top locked tables and which particular row is locked, Is it possible to get ?
Just search for 'lock'

mysql&gt; pager grep -C 3 -i lock
PAGER set to 'grep -C 3 -i lock'
mysql&gt; show engine innodb status\G
... results ...
1 row in set (0.00 sec)

mysql&gt; \n
PAGER set to stdout
mysql&gt;