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.
Table 20.5 INNODB_LOCKS Columns
|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 126.96.36.199, “Granularity of INFORMATION_SCHEMA Data”.
You must have the
PROCESS privilege to
query this table.
For usage information, see Section 188.8.131.52, “Using the Transaction Information Schema Tables”.