Help Center/ Data Admin Service/ User Guide/ MySQL/ Intelligent O&M (New Version)/ Locks and Transactions/ Metadata Locks
Updated on 2025-03-24 GMT+08:00
View PDF

Metadata Locks

Metadata locks (MDLs) are used to ensure consistency between DDL and DML operations. Executing DDL statements on a table generates metadata write locks. If there is a metadata lock, all subsequent SELECT, DML, and DDL operations on the table will be blocked, causing a connection backlog.

Metadata locks are displayed in real time. You can quickly identify problems and terminate the sessions with metadata locks to restore blocked operations.

Precautions

  • DML locks are not included. You can view and analyze them on the InnoDB Locks page.
  • Metadata locks are used only in MySQL 5.6 and 5.7.
  • A maximum of 1,000 records can be displayed.

Procedure

  1. Click in the upper left corner and select a region and project.
  2. Click in the upper left corner, and under Databases, click Data Admin Service.
  3. In the navigation pane, choose Intelligent O&M > Instance List.
  4. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
  5. Locate the box containing your target instance and click Details.
  6. Choose Locks and Transactions > Metadata Locks.
  7. Select a lock status and type, enter a database name, table name, and session ID as needed, and click Query.
  8. In the query result, check whether there are sessions that hold MDL locks. If yes, select the sessions as required and click Kill.
Parent topic: Locks and Transactions