Information Schema INNODB_LOCK_WAITS Table

The Information Schema INNODB_LOCK_WAITS table maps blocked transactions to the transactions that are blocking them, aiding in deadlock analysis.

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.

_{This page is licensed: CC BY-SA / Gnu FDL}