Help Center > > User Guide> MySQL Database Management> DB Instance Management> Querying InnoDB Locks

Querying InnoDB Locks

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

InnoDB lock status management allows you to diagnose conflicts during execution of transactions or sessions with a few clicks. By querying the lock status, you can obtain the lock-holding and lock-wait information of transactions, such as the transaction status, session ID, locked table, and locked data range.

Currently, the InnoDB lock status query is in the open beta test period.

Prerequisites

You have logged in to the DAS console.

Procedures

On the menu bar, choose Instance Management > InnoDB Lock Query.
  1. On the displayed page, the lock-holding and lock-wait information is displayed if a transaction is waiting for a lock.
    Move the cursor above the image to view detailed information.
    • The default lock wait timeout is 50s. You can modify the innodb_lock_wait_timeout parameter to change the timeout value.
    • The SQL window execution timeout is 300s.
    • The lock wait timeout value is the smaller one of the default wait time and the SQL window execution time (300s).
  2. If there is no transaction waiting for a lock, click the refresh button or click Demo to view the latest lock query information.

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