Recently, I saw many interest in understanding and getting information about database locking. MySQL InnoDB’s locking can be complex and having an overview not always simple. For more information about how InnoDB locking is working, I can only recommend this…
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…
With MySQL 8.0, engineers improved the visibility of data locking. Usually it was not that easy to deal with the output of SHOW ENGINE INNODB STATUS and mixing Information_Schema tables like INNODB_LOCKS and INNODB_LOCK_WAITS. So in MySQL 8.0 we instrument…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.