Help Center > > User Guide> Intelligent O&M> Intelligent O&M for RDS for MySQL and GaussDB(for MySQL) DB Instances> Locks and Transactions> InnoDB Lock Query
InnoDB Lock Query
Updated at: Jun 09, 2021 GMT+08:00
With this function, 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.
This feature does not support DDL locks. You view and analyze them on the Metadata Locks page.
- 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 Lock Query to check whether there are lock waits.