Updated on 2023-12-13 GMT+08:00

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

  • This function does not support DML locks. 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. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane, choose Intelligent O&M > Instance List.

    Alternatively, on the Overview page, click Go to Intelligent O&M.

  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.

    Figure 1 Searching for instances

  6. Locate the box containing your target instance and click Details.
  7. In the upper right corner of the page, click Go to Old Edition.

    Figure 2 Accessing Intelligent O&M of the old version

  8. Choose Locks and Transactions > Metadata Locks.
  9. Select a lock status and type, enter a database name, table name, and session ID as needed, and click Query.
  10. In the query result, check whether there are sessions that hold MDL locks. If yes, select the sessions as required and click Kill.