INNODB_LOCK_WAITS table contains
one or more rows for each blocked
transaction, indicating the lock it has requested and any locks
that are blocking that request.
|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.3.2, “Granularity of
You must have the
PROCESS privilege to
query this table.
For usage information, see Section 188.8.131.52.2.1, “Using the Transaction Information Schema Tables”.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices