Aikesheng Open Source Community
Jun 18, 2020 · Databases
How to Query MySQL Metadata Locks Using the MySQL Shell Plugin
This article explains MySQL's metadata lock mechanism and demonstrates how to use the ext.check.get_locks() function from the MySQL Shell plugin—along with a supporting SQL query—to list lock owners, statements, and lock types, including setup steps for MySQL 5.7.
MySQLPerformance SchemaSQL Query
0 likes · 3 min read