6.29 Sys Schema InnoDB Row Lock Waits Metrics

Lists the Sys Schema InnoDB Row Lock Waits metrics and provides a brief description of each.

Table 6.29 Sys Schema InnoDB Row Lock Wait Metrics

Name	Description
Blocking Lock Id	Lock ID of the transaction that is blocking
Blocking Lock Mode	Lock mode of the transaction that is blocking
Blocking Pid	Process ID of the transaction that is blocking
Blocking Query	Running statement of the transaction that is blocking
Blocking Trx Age	Age of the transaction that is blocking (in milliseconds)
Blocking Trx Id	Transaction ID of the transaction that is blocking
Blocking Trx Rows Locked	Rows locked by the transaction that is blocking
Blocking Trx Rows Modified	Rows modified by the transaction that is blocking
Blocking Trx Started	When the transaction that is blocking started
Locked Index	Which index is locked
Locked Table	Which table is locked
Locked Type	Locked Type
Wait Age	How long in milliseconds this wait has waited
Waiting Lock Id	Lock ID of the transaction that is waiting
Waiting Lock Mode	Lock mode of the transaction that is waiting
Waiting Pid	Process ID of the transaction that is waiting
Waiting Query	Running statement of the transaction that is waiting
Waiting Trx Age	Age in milliseconds of the transaction that is waiting
Waiting Trx Id	Identifier of the transaction that is waiting
Waiting Trx Rows Locked	Rows locked by the transaction that is waiting
Waiting Trx Rows Modified	Rows modified by the transaction that is waiting
Waiting Trx Started	When the transaction that is waiting started
Wait Started	When this wait started