InnoDB - How to get top locked tables and rows which are locked
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;