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

Name	Description
Checkpoint File	The 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 Lsn	The 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 File	The 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 Lsn	The 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 Sec	The 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 Lsn	The redo log sequence number within InnoDB, up to which the buffer pool has been flushed to the data files.
Pending Checkpoint Writes	The total number of currently pending checkpoint writes within InnoDB.
Pending Log Writes	The total number of writes pending to the InnoDB redo logs.
Sequence File	The 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 Number	The 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.