MySQL: Script to identify the locks and blocking transactions

In this DBA Scripts category, I am sharing one script to find locks and blocking transaction of the MySQL Server.

The table locks and blocking transaction are a very common thing in any database system.
As a Database Administrator, this is our responsibility to find all locked and blocked transactions of MySQL Server.

Below is a script (work for MySQL 5.5 and above versions) :

Anvesh Patel

Leave a Reply

2 Comments on "MySQL: Script to identify the locks and blocking transactions"

Notify of
Sort by:   newest | oldest | most voted

Hi ,
Do know how to use debugger in PL/SQL developer tool and what permission are required ?