Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
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 20.6. 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 onLOCK_ID.
|
Notes:
Use this table to help diagnose performance problems that occur during times of
heavy concurrent load. Its contents are updated as described in Section
14.2.4.3.4.2, "Granularity of INFORMATION_SCHEMA Data".
You must have the PROCESS privilege to query this
table.
For usage information, see Section 14.2.4.3.2.1, "Using the Transaction Information Schema Tables".