Lists the InnoDB Log Activity metrics and provides a brief description of each.
Table 4.12 InnoDB Log Activity Metrics
| Name | Description |
|---|---|
| Checkpoint File (Total) | The low order 32bit value for the redo log sequence numberwithin 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 (Total) | The redo log sequence number within InnoDB, up to whichcheckpointing (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 (Total) | The low order 32bit value for the redo log sequence numberwithin InnoDB, up to which the redo log buffer has been flushed to theredo log files. This is only available prior to the 5.1.x plugin and 5.5.x. |
| Flushed Lsn (Total) | The redo log sequence number within InnoDB, up to which theredo 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 (Total) | The per second average number of IO operations for theInnoDB redo logs. |
| Io Total (Delta) | The total number of IO operations for the InnoDB redo logs. |
| Pages Flushed Lsn (Total) | The redo log sequence number within InnoDB, up to which the buffer pool has been flushed to the data files. |
| Pending Checkpoint Writes (Total) | The total number of currently pending checkpoint writeswithin InnoDB. |
| Pending Log Writes (Total) | The total number of writes pending to the InnoDB redo logs. |
| Sequence File (Total) | The low order 32bit value for the redo log sequence numberwithin InnoDB. This is only available prior to the 5.1.x plugin and 5.5.x. |
| Sequence Number (Total) | 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. |