WL#9629: Enable PFS MDL instrumentation by Default
Affects: Server-8.0
—
Status: Complete
MDL instrumentation is useful for understanding lurking locking problems, which
are not clear in SHOW PROCESSLIST etc.
We can create some nice views of MDL in SYS once it is enabled:
performance-schema-instrument='wait/lock/metadata/sql/%=ON'
For example:
https://bugs.mysql.com/bug.php?id=80823
User Documentation
==================
* https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-2.html
* https://dev.mysql.com/doc/refman/8.0/en/metadata-locks-table.html
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.