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. |