6.18 InnoDB Transaction Activity Metrics

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.