Help Center/
Data Admin Service/
User Guide (ME-Abu Dhabi Region)/
User Guide/
Intelligent O&M/
MySQL DB Instances/
Locks and Transactions/
InnoDB Lock Query
Updated on 2023-03-28 GMT+08:00
InnoDB Lock Query
Overview
With this feature, the system displays the lock waits generated before the DML operations on the database in real time. With these waits, 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 quickly terminate the source session that holds locks to restore blocked operations.
![](https://support.huaweicloud.com/intl/en-us/ae-ad-1-usermanual-das/public_sys-resources/note_3.0-en-us.png)
This feature 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 DAS console using your username and password.
- On the Overview page, click Go to Intelligent O&M.
- Locate your desired instance and click Details to go to the Intelligent O&M overview page.
- Choose Locks and Transactions > InnoDB Locks to check whether there are lock waits.
Parent topic: Locks and Transactions
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot