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> pager grep -C 3 -i lock
PAGER set to 'grep -C 3 -i lock'
mysql> show engine innodb status\G
... results ...
1 row in set (0.00 sec)

mysql> \n
PAGER set to stdout

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.