Lists the InnoDB Io Activity metrics and provides a brief description of each.
Table 4.11 InnoDB Io Activity Metrics
| Name | Description |
|---|---|
| Bytes Per Read (Total) | The average bytes per read within InnoDB for the snapshot interval. |
| Open Files (Total) | The number of open files within InnoDB. |
| Os File Fsyncs (Delta) | The total number of fsync() operations performed by InnoDB. |
| Os File Reads (Delta) | The total number of files reads performed by read threadswithin InnoDB. |
| Os File Writes (Delta) | The total number of file writes performed by write threadswithin InnoDB. |
| Pending Flushes Bp (Total) | The number of pending buffer flush operations within InnoDB. |
| Pending Flushes Log (Total) | The number of pending redo log flush operations within InnoDB. |
| Pending Ibuf Reads (Total) | The number of pending asynchronous read requests for the secondary index insert buffer within InnoDB. |
| Pending Reads (Total) | The number of pending normal asynchronous IO read requests for data within InnoDB. |
| Pending Redo Log (Total) | The number of pending IO requests (read or write) for theInnoDB redo logs. |
| Pending Sync (Total) | The number of pending synchronous IO requests (from user threads rather than background threads) within InnoDB. |
| Pending Writes (Total) | The number of pending normal asynchronous IO write requests for data within InnoDB. |
| Reads Per Sec (Total) | The average number of file reads per second within InnoDB for the snapshot interval. |
| Syncs Per Sec (Total) | The average number of fsync() operations per second within InnoDB for the snapshot interval. |
| Writes Per Sec (Total) | The average number of file writes per second within InnoDB for the snapshot interval. |