wait_started

The time at which the lock wait started.

wait_age

How long the lock has been waited for, as a TIME value.

wait_age_secs

How long the lock has been waited for, in seconds.

locked_table

The name of the locked table. This column contains combined schema/table name values.

locked_index

The name of the locked index.

locked_type

The type of the waiting lock.

waiting_trx_id

The ID of the waiting transaction.

waiting_trx_started

The time at which the waiting transaction started.

waiting_trx_age

How long the waiting transaction has been waiting, as a TIME value.

waiting_trx_rows_locked

The number of rows locked by the waiting transaction.

waiting_trx_rows_modified

The number of rows modified by the waiting transaction.

waiting_pid

The processlist ID of the waiting transaction.

waiting_query

The statement that is waiting for the lock.

waiting_lock_id

The ID of the waiting lock.

waiting_lock_mode

The mode of the waiting lock.

blocking_trx_id

The ID of the transaction that is blocking the waiting lock.

blocking_pid

The processlist ID of the blocking transaction.

blocking_query

The 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_id

The ID of the lock that is blocking the waiting lock.

blocking_lock_mode

The mode of the lock that is blocking the waiting lock.

blocking_trx_started

The time at which the blocking transaction started.

blocking_trx_age

How long the blocking transaction has been executing, as a TIME value.

blocking_trx_rows_locked

The number of rows locked by the blocking transaction.

blocking_trx_rows_modified

The number of rows modified by the blocking transaction.

sql_kill_blocking_query

The KILL statement to execute to kill the blocking statement.

sql_kill_blocking_connection

The KILL statement to execute to kill the session running the blocking statement.