Oracle Enterprise Manager for MySQL Database
Lists the InnoDB Transaction Activity metrics and provides a brief description of each.
Table 6.18 InnoDB Transaction Activity Metrics
| Name | Description |
|---|---|
| Committing Count | The total number of transactions currently committing within InnoDB. |
| Current Lock Wait Count Total | The total number of rows lock waits within all currently running transactions. |
| Latest Deadlock | The latest deadlock reported by SHOW ENGINE INNODB STATUS. |
| Latest Foreign Key Error | The latest foreign key error reported by SHOW ENGINE INNODB STATUS. |
| Lock Memory Bytes Total | The total number of bytes allocated for lock memory for all currently running transactions. |
| Lock Wait Count | The total number of transactions waiting for row locks within InnoDB. |
| Rolling Back Count | The total number of transactions currently rolling back within InnoDB. |
| Rows Locked Total | The total number of rows locked within all currently running transactions. |
| Rows Modified Total | The total number of rows modified within all currently running transactions. |
| Running Count | The total number of transactions currently running within InnoDB. |
| Trx History List Length | The number of transactions that currently have undo space allocated to them (unpurged). |
| Trx Id Counter1 | The low order 32bit value for the internal transaction counter within InnoDB. This is only available prior to the 5.1.x plugin and 5.5.x. |
| Trx Id Counter2 | The second 32bit internal transaction counter within InnoDB. This is only available prior to the 5.1.x plugin and 5.5.x. |
| Trx Id Counter Str | The hexadecimal representation of the internal InnoDB transaction counter, available only on 5.5.x+, or 5.1.x with the plugin. |
| Trx Purge Done Trx2 | The transaction counter to which the InnoDB purge process has completed. |
| Trx Total Lock Structs | The total number of lock structs in use by all transactions within InnoDB. |