# 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.
- 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.
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.
   - 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: Intelligent O&M