Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.7Kb
HTML Download (Zip) - 231.2Kb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  InnoDB Transaction Activity Metrics

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

NameDescription
Committing CountThe total number of transactions currently committing within InnoDB.
Current Lock Wait Count TotalThe total number of rows lock waits within all currently running transactions.
Latest DeadlockThe latest deadlock reported by SHOW ENGINE INNODB STATUS.
Latest Foreign Key ErrorThe latest foreign key error reported by SHOW ENGINE INNODB STATUS.
Lock Memory Bytes TotalThe total number of bytes allocated for lock memory for all currently running transactions.
Lock Wait CountThe total number of transactions waiting for row locks within InnoDB.
Rolling Back CountThe total number of transactions currently rolling back within InnoDB.
Rows Locked TotalThe total number of rows locked within all currently running transactions.
Rows Modified TotalThe total number of rows modified within all currently running transactions.
Running CountThe total number of transactions currently running within InnoDB.
Trx History List LengthThe number of transactions that currently have undo space allocated to them (unpurged).
Trx Id Counter1The 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 Counter2The 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 StrThe hexadecimal representation of the internal InnoDB transaction counter, available only on 5.5.x+, or 5.1.x with the plugin.
Trx Purge Done Trx2The transaction counter to which the InnoDB purge process has completed.
Trx Total Lock StructsThe total number of lock structs in use by all transactions within InnoDB.