19.30.5. The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
The INNODB_LOCK_WAITS table contains one or
more rows for each blocked InnoDB transaction,
indicating the lock it has requested and any locks that are
blocking that request.
Table 19.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.
Notes:
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.
© 2012, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.