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

Overview

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.

Procedure

  1. Log in to the DAS console using your username and password.
  2. On the Overview page, click Go to Intelligent O&M.
  3. Locate your desired instance and click Details to go to the Intelligent O&M overview page.
  4. Choose Locks and Transactions > InnoDB Lock Query to check whether there are lock waits.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel