Help Center/ Data Admin Service/ User Guide (Kuala Lumpur Region)/ User Guide/ MySQL/ Intelligent O&M/ Locks and Transactions/ InnoDB Locks
Updated on 2025-01-07 GMT+08:00
View PDF
Share

InnoDB Locks

InnoDB lock waits generated before DML operations are displayed in real time. You can quickly locate the session waits and blocks that happened when multiple sessions update the same piece of data at the same time, and can terminate the source session that holds locks to restore blocked operations.

InnoDB Locks does not support metadata locks (MDLs). You view and analyze them on the Metadata Locks page.

Procedure

  1. Log in to the DAS 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.
  5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
  6. Locate the box containing your target instance and click Details.
  7. Choose Locks and Transactions > InnoDB Locks to check whether there are lock waits.
Parent topic: Locks and Transactions