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.
2. On the displayed page, the lock-holding and lock-wait information is displayed if a transaction is waiting for a lock.
3. Move the cursor above an icon to view its detailed information.
4. Click the lock-holding or lock-wait icon. A dialog box for killing the session is displayed.
   Note

   • 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.