Help Center> Data Admin Service> User Guide> MySQL DB Instance Management (Standard Edition)> CloudDBA> InnoDB Lock Query
View PDF

InnoDB Lock Query

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, InnoDB lock status query is in the open beat testing period.

Procedures

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