Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  Sys Schema InnoDB Row Lock Waits Metrics

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

NameDescription
Blocking Lock IdLock ID of the transaction that is blocking
Blocking Lock ModeLock mode of the transaction that is blocking
Blocking PidProcess ID of the transaction that is blocking
Blocking QueryRunning statement of the transaction that is blocking
Blocking Trx AgeAge of the transaction that is blocking (in milliseconds)
Blocking Trx IdTransaction ID of the transaction that is blocking
Blocking Trx Rows LockedRows locked by the transaction that is blocking
Blocking Trx Rows ModifiedRows modified by the transaction that is blocking
Blocking Trx StartedWhen the transaction that is blocking started
Locked IndexWhich index is locked
Locked TableWhich table is locked
Locked TypeLocked Type
Wait AgeHow long in milliseconds this wait has waited
Waiting Lock IdLock ID of the transaction that is waiting
Waiting Lock ModeLock mode of the transaction that is waiting
Waiting PidProcess ID of the transaction that is waiting
Waiting QueryRunning statement of the transaction that is waiting
Waiting Trx AgeAge in milliseconds of the transaction that is waiting
Waiting Trx IdIdentifier of the transaction that is waiting
Waiting Trx Rows LockedRows locked by the transaction that is waiting
Waiting Trx Rows ModifiedRows modified by the transaction that is waiting
Waiting Trx StartedWhen the transaction that is waiting started
Wait StartedWhen this wait started