> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_lock_waits-table.md).

# Information Schema INNODB\_LOCK\_WAITS Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `INNODB_LOCK_WAITS` table contains information about blocked InnoDB transactions. The `PROCESS` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md) is required to view the table.

It contains the following columns:

| Column              | Description                                                                                                                                                                                                                                                              |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| REQUESTING\_TRX\_ID | Requesting transaction ID from the [INNODB\_TRX](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_trx-table.md) table.                                                       |
| REQUESTED\_LOCK\_ID | Lock ID from the [INNODB.LOCKS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_locks-table.md) table for the waiting transaction.                                          |
| BLOCKING\_TRX\_ID   | Blocking transaction ID from the [INNODB\_TRX](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_trx-table.md) table.                                                         |
| BLOCKING\_LOCK\_ID  | Lock ID from the [INNODB.LOCKS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_locks-table.md) table of a lock held by a transaction that is blocking another transaction. |

The table is often used in conjunction with the [INNODB\_LOCKS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_locks-table.md) and [INNODB\_TRX](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_trx-table.md) tables to diagnose problematic locks and transactions.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}