INNODB_LOCK_WAITS table contains
one or more rows for each blocked
transaction, indicating the lock it has requested and any locks
that are blocking that request.
|ID of the requesting transaction.|
|ID of the lock for which a transaction is waiting. Details about the
lock can be found by joining with
|ID of the blocking transaction.|
|ID of a lock held by a transaction blocking another transaction from
proceeding. Details about the lock can be found by joining
Use this table to help diagnose performance problems that occur during times of heavy concurrent load.
You must have the
PROCESS privilege to
query this table.
For usage information, see Section 184.108.40.206.4, “Using the Transaction Information Schema Tables”.