All posts by Morgan Tocker

About Morgan Tocker

Morgan is the Product Manager for the MySQL Server.

Meet the MySQL Engineering Team

A number of members of the MySQL Engineering Team will be at Percona Live and the MySQL Innovation Day over the next week or so. Here is where you can find us:

Tuesday 19 April 2016

Wednesday 20 April 2016

Thursday 21 April

Monday 25 April

We’ll all be present at the MySQL Innovation Day.…

Extending the SYS schema to show metadata locks

Starting with MySQL 5.7, performance_schema has been enhanced to instrument metadata locks, and can be turned on by adding the following line to your my.cnf file:

(At runtime, it can also be enabled by modifying the setup_instruments table in performance_schema.)

From here, you can now query performance_schema.metadata_locks to reveal all currently open metadata locks on your server: