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) :

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

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 ?