Help Center > > User Guide> GaussDB(for MySQL) DB Instance Management (Development Tool)> Intelligent O&M> InnoDB Lock Query

InnoDB Lock Query

Updated at: Jun 09, 2021 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.
  • InnoDB Lock Query is currently in open beta testing.

Procedure

  1. On the top menu bar, choose Intelligent O&M > InnoDB Lock Query. If there is no transaction waiting for a lock, click Refresh to view the latest lock query information.
  2. On the displayed page, the lock-holding and lock-wait information is displayed if a transaction is waiting for a lock.
    Figure 1 Querying the InnoDB lock
  3. Move the cursor above an icon to view its detailed information.
    Figure 2 Lock details
  4. Click the lock-holding or lock-wait icon. A dialog box for killing the session is displayed.
    Figure 3 Killing sessions
    • 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.

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