mysql 5.7

https://dev.mysql.com/doc/refman/5.7/en/metadata-locks-table.html

As of MySQL 5.7.3, the Performance Schema exposes metadata lock information through the metadata_locks table

Metadata lock instrumentation is disabled by default. To enable it, enable the wait/lock/metadata/sql/mdl instrument in the setup_instruments table.

percona server 5.7

https://www.percona.com/doc/percona-server/5.7/changed_in_57.html

Changes in Percona Server 5.6 features

The performance_schema.metadata_locks table now displays backup and binlog lock

slides on perf_schema

Using Performance Schema to Monitor and Troubleshoot MySQL 5.6: https://www.percona.com/resources/technical-presentations/using-performance-schema-monitor-and-troubleshoot-mysql-56-percona

Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks: https://www.percona.com/resources/mysql-webinars/using-mysql-56-performance-schema-troubleshoot-typical-workload-bottlenecks

More on (transactional) MySQL metadata locks

https://www.percona.com/blog/2015/04/07/more-on-transactional-mysql-metadata-locks/

DB/mysql_metadata_locks (last edited 2016-02-15 17:53:49 by lena)