Last Tuesday, it was the very first session of DB AMA, Morgan Tocker made a nice presentation of MySQL Performance_Schema and illustrated it with some nice queries to get Meta et Data Locks.
As those queries were not that simple to write or at least to remember, I thought it might be a good idea to add them to MySQL Shell, the best MySQL DBA Tool ! 😉
I’ve then added a new method to the check
plugin: getLocks()
.
Let’t see it in action:
As you can see, this is a small extension that can offers you a better view of what’s locked per transaction.
You can find several MySQL Shell Extension directly on github: https://github.com/lefred/mysqlshell-plugins