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.
This table is deprecated and is removed as of MySQL 8.0.1. Use the Performance Schema data_lock_waits table instead. See Section 27.12.13.2, “The data_lock_waits Table”.
The tables differ in the privileges required: The INNODB_LOCK_WAITS table requires the global PROCESS privilege. The data_lock_waits table requires the usual Performance Schema privilege of SELECT on the table to be selected from.
The following table shows the mapping from INNODB_LOCK_WAITS columns to data_lock_waits columns. Use this information to migrate applications from one table to the other.
Table 26.8 Mapping from INNODB_LOCK_WAITS to data_lock_waits Columns
| INNODB_LOCK_WAITS Column | data_lock_waits Column |
|---|---|
REQUESTING_TRX_ID | REQUESTING_ENGINE_TRANSACTION_ID |
REQUESTED_LOCK_ID | REQUESTING_ENGINE_LOCK_ID |
BLOCKING_TRX_ID | BLOCKING_ENGINE_TRANSACTION_ID |
BLOCKING_LOCK_ID | BLOCKING_ENGINE_LOCK_ID |