Enterprise Manager
Lists the Sys Schema InnoDB Row Lock Waits metrics and provides a brief description of each.
Table 6.32 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 |