Lists the InnoDB Transaction Activity metrics and provides a brief description of each.
Table 4.16 InnoDB Transaction Activity Metrics
| Name | Description |
|---|---|
| Committing Count (Total) | The total number of transactions currently committing within InnoDB. |
| Current Lock Wait Count Total (Total) | The total number of rows lock waits within all currently running transactions. |
| Latest Deadlock (Total) | The latest deadlock reported by SHOW ENGINE INNODB STATUS. |
| Latest Foreign Key Error (Total) | The latest foreign key error reported by SHOW ENGINE INNODB STATUS. |
| Lock Memory Bytes Total (Total) | The total number of bytes allocated for lock memory for all currently running transactions. |
| Lock Wait Count (Total) | The total number of transactions waiting for row locks within InnoDB. |
| Rolling Back Count (Total) | The total number of transactions currently rolling back within InnoDB. |
| Rows Locked Total (Total) | The total number of rows locked within all currently running transactions. |
| Rows Modified Total (Total) | The total number of rows modified within all currently running transactions. |
| Running Count (Total) | The total number of transactions currently running within InnoDB. |
| Trx History List Length (Total) | The number of transactions that currently have undo spaceallocated to them (unpurged). |
| Trx Id Counter1 (Total) | 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 (Total) | 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 (Total) | The hexidecimal representation of the internal InnoDB transaction counter, available only on 5.5.x+, or 5.1.x with the plugin. |
| Trx Purge Done Trx2 (Total) | The transaction counter to which the InnoDB purge process has completed. |
| Trx Total Lock Structs (Total) | The total number of lock structs in use by all transactions within InnoDB. |