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 management 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.

Figure 1 Searching for instances
Locate the box containing your target instance and click Details.
In the upper right corner of the page, click Go to Old Edition.

Figure 2 Accessing Intelligent O&M of the old version
Choose Locks and Transactions > InnoDB Locks to check whether there are lock waits.