INNODB_LOCK_WAITS table contains one or
more rows for each blocked
indicating the lock it has requested and any locks that are
blocking that request.
Table 21.6 INNODB_LOCK_WAITS Columns
|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. Its contents are updated as described in Section 126.96.36.199, “Data Persistence and Consistency for InnoDB Transaction and Locking Tables”.
You must have the
PROCESS privilege to
query this table.
For usage information, see Section 188.8.131.52, “Usage Examples for InnoDB Transaction and Locking Tables”.