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.8Kb
HTML Download (Zip) - 231.3Kb


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

6.14 InnoDB Log Activity Metrics

Lists the InnoDB Log Activity metrics and provides a brief description of each.

Table 6.14 InnoDB Log Activity Metrics

NameDescription
Checkpoint FileThe low order 32bit value for the redo log sequence number within InnoDB, up to which checkpointing (flushing from the buffer to disk) has completed. This is only available prior to the 5.1.x plugin and 5.5.x.
Checkpoint LsnThe redo log sequence number within InnoDB, up to which checkpointing (flushing from the buffer to disk) has completed. On versions prior to the 5.1.x plugin and 5.5.x this is the high order 32bit value, on later versions it is the full 64bit LSN value up to which checkpoints have completed.
Flushed FileThe low order 32bit value for the redo log sequence number within InnoDB, up to which the redo log buffer has been flushed to the redo log files. This is only available prior to the 5.1.x plugin and 5.5.x.
Flushed LsnThe redo log sequence number within InnoDB, up to which the redo log buffer has been flushed to the redo log files. On versions prior to the 5.1.x plugin and 5.5.x this is the high order 32bit value, on later versions it is the full 64bit LSN value up to which the buffer has been flushed.
IO Per SecThe per second average number of IO operations for the InnoDB redo logs.
IO Total (Delta)The total number of IO operations for the InnoDB redo logs.
Pages Flushed LsnThe redo log sequence number within InnoDB, up to which the buffer pool has been flushed to the data files.
Pending Checkpoint WritesThe total number of currently pending checkpoint writes within InnoDB.
Pending Log WritesThe total number of writes pending to the InnoDB redo logs.
Sequence FileThe low order 32bit value for the redo log sequence number within InnoDB. This is only available prior to the 5.1.x plugin and 5.5.x.
Sequence NumberThe current redo log sequence number within InnoDB. On versions prior to the 5.1.x plugin and 5.5.x this is the high order 32bit value, on later versions it is the full 64bit LSN value.