Help Center > > User Guide> Intelligent O&M> Intelligent O&M for RDS for MySQL and GaussDB(for MySQL) DB Instances> Locks and Transactions> Metadata Locks

Metadata Locks

Updated at: Jun 09, 2021 GMT+08:00

Overview

  • Metadata locks (MDLs) are used to ensure consistency between DDL and DML operations. Usually, DDL operations require MDL write locks. Once a DML lock occurs, it can have a significant impact on the database because all subsequent operations (SELECT, DML, and DDL operations) on the table will be blocked, causing a backlog of connections.
  • The system displays the database MDL locks in real time. With these locks, you can quickly locate MDL problems and terminate the sessions holding MDL locks, so that blocked operations can be restored.
    • This feature does not support DML locks. You can view and analyze them on the InnoDB Lock Query page.
    • Currently, this feature is available for only MySQL 5.6 and 5.7.
    • A maximum of 1,000 records can be displayed.
    • GaussDB(for MySQL) DB instances are currently not supported.

Procedure

  1. Log in to the DAS console using your username and password.
  2. On the Overview page, click Go to Intelligent O&M.
  3. Locate your desired instance and click Details to go to the Intelligent O&M overview page.
  4. Choose Locks and Transactions > Metadata Locks.
  5. Select a lock status and type, and enter a database name, table name, and session ID as needed. Then, click Query to query required sessions.
  6. In the query result, check whether there are sessions that hold MDL locks. If so, select the sessions as required and click Kill Session.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel