Help Center > > User Guide> MySQL DB Instance Management (Development Tool)> Intelligent O&M> InnoDB Lock Query
InnoDB Lock Query
Updated at: Jun 09, 2021 GMT+08:00
- 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.
- 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.Figure 1 InnoDB lock query
- 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
- Move the cursor above an icon to view its detailed information.Figure 3 Lock details
- 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.