Help Center/ Data Admin Service/ User Guide/ MySQL/ Intelligent O&M (New Version)/ Locks and Transactions/ InnoDB Locks
Updated on 2024-08-29 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 DDL locks, also called 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.

    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. Choose Locks and Transactions > InnoDB Locks to check whether there are lock waits.
Parent topic: Locks and Transactions