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