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.