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. |