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

Log in to the console.
Click in the upper left corner and select a region and project.
Click in the upper left corner, and under Databases, click Data Admin Service.
In the navigation pane, choose Intelligent O&M > Instance List.

Alternatively, on the Overview page, click Go to Intelligent O&M.
In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
Locate the target instance and click Details. The Dashboard page is displayed.
Click the Locks and Transactions tab.
Click the Locks and Transactions tab and then InnoDB Locks to check whether there are lock waits.

Figure 1 InnoDB locks