Using this table, you can tell which transactions are
waiting for a given lock, or for which lock a given transaction
is waiting. This table contains one or more rows for each
blocked transaction, indicating the lock it
has requested and the lock(s) that is (are) blocking that
request. The REQUESTED_LOCK_ID refers to the lock that a
transaction is requesting, and the BLOCKING_LOCK_ID refers to
the lock (held by another transaction) that is preventing the
first transaction from proceeding. For any given blocked
transaction, all rows in INNODB_LOCK_WAITS have the same value
for REQUESTED_LOCK_ID and different values for
BLOCKING_LOCK_ID.
Table 6.5. INNODB_LOCK_WAITS columns
| Column name | Description |
|---|---|
REQUESTING_TRX_ID
|
ID of the requesting transaction. |
REQUESTED_LOCK_ID
|
ID of the lock for which a transaction is waiting.
Details about the lock can be found by joining with
INNODB_LOCKS on LOCK_ID.
|
BLOCKING_TRX_ID
|
ID of the blocking transaction. |
BLOCKING_LOCK_ID
|
ID of a lock held by a transaction blocking another
transaction from proceeding. Details about the lock
can be found by joining with INNODB_LOCKS on
LOCK_ID.
|
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
