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 20.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 22.214.171.124, “Granularity of INFORMATION_SCHEMA Data”.
You must have the
PROCESS privilege to
query this table.
For usage information, see Section 126.96.36.199, “Using the Transaction Information Schema Tables”.