The Information Schema INNODB_LOCK_WAITS table contains information about blocked InnoDB transactions. The PROCESS privilege is required to view the table.
It contains the following columns:
| Column | Description |
|---|---|
REQUESTING_TRX_ID |
Requesting transaction ID from the INNODB_TRX table. |
REQUESTED_LOCK_ID |
Lock ID from the INNODB.LOCKS table for the waiting transaction. |
BLOCKING_TRX_ID |
Blocking transaction ID from the INNODB_TRX table. |
BLOCKING_LOCK_ID |
Lock ID from the INNODB.LOCKS table of a lock held by a transaction that is blocking another transaction. |
The table is often used in conjunction with the INNODB_LOCKS and INNODB_TRX tables to diagnose problematic locks and transactions.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-innodb_lock_waits-table/