INNODB_LOCKS table contains information
about each lock that an
InnoDB transaction has
requested but not yet acquired, and each lock that a transaction
holds that is blocking another transaction.
|Unique lock ID number, internal to |
|ID of the transaction holding this lock. Details about the transaction
can be found by joining with |
|Mode of the lock. One of |
|Type of the lock. One of |
|Name of the table that has been locked or contains locked records.|
|Name of the index if |
|Tablespace ID of the locked record if
|Page number of the locked record if
|Heap number of the locked record within the page if
|Primary key of the locked record if
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
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”.