MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

27.4.3.9 The innodb_lock_waits and x$innodb_lock_waits Views

These views summarize the InnoDB locks that transactions are waiting for. By default, rows are sorted by descending lock age.

The innodb_lock_waits and x$innodb_lock_waits views have these columns: