MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
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:
wait_startedThe time at which the lock wait started.
wait_ageHow long the lock has been waited for, as a
TIMEvalue.wait_age_secsHow long the lock has been waited for, in seconds.
locked_table_schemaThe schema that contains the locked table.
locked_table_nameThe name of the locked table.
locked_table_partitionThe name of the locked partition, if any;
NULLotherwise.locked_table_subpartitionThe name of the locked subpartition, if any;
NULLotherwise.locked_indexThe name of the locked index.
locked_typeThe type of the waiting lock.
waiting_trx_idThe ID of the waiting transaction.
waiting_trx_startedThe time at which the waiting transaction started.
waiting_trx_ageHow long the waiting transaction has been waiting, as a
TIMEvalue.waiting_trx_rows_lockedThe number of rows locked by the waiting transaction.
waiting_trx_rows_modifiedThe number of rows modified by the waiting transaction.
waiting_pidThe processlist ID of the waiting transaction.
waiting_queryThe statement that is waiting for the lock.
waiting_lock_idThe ID of the waiting lock.
waiting_lock_modeThe mode of the waiting lock.
blocking_trx_idThe ID of the transaction that is blocking the waiting lock.
blocking_pidThe processlist ID of the blocking transaction.
blocking_queryThe statement the blocking transaction is executing. This field reports NULL if the session that issued the blocking query becomes idle. For more information, see Identifying a Blocking Query After the Issuing Session Becomes Idle.
blocking_lock_idThe ID of the lock that is blocking the waiting lock.
blocking_lock_modeThe mode of the lock that is blocking the waiting lock.
blocking_trx_startedThe time at which the blocking transaction started.
blocking_trx_ageHow long the blocking transaction has been executing, as a
TIMEvalue.blocking_trx_rows_lockedThe number of rows locked by the blocking transaction.
blocking_trx_rows_modifiedThe number of rows modified by the blocking transaction.
sql_kill_blocking_queryThe
KILLstatement to execute to kill the blocking statement.sql_kill_blocking_connectionThe
KILLstatement to execute to kill the session running the blocking statement.