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


6.13 InnoDB IO Activity Metrics

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

Table 6.13 InnoDB IO Activity Metrics

NameDescription
Bytes Per ReadThe average bytes per read within InnoDB for the snapshot interval.
Open FilesThe 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 threads within InnoDB.
Os File Writes (Delta)The total number of file writes performed by write threads within InnoDB.
Pending Flushes BpThe number of pending buffer flush operations within InnoDB.
Pending Flushes LogThe number of pending redo log flush operations within InnoDB.
Pending Ibuf ReadsThe number of pending asynchronous read requests for the secondary index insert buffer within InnoDB.
Pending ReadsThe number of pending normal asynchronous IO read requests for data within InnoDB.
Pending Redo LogThe number of pending IO requests (read or write) for the InnoDB redo logs.
Pending SyncThe number of pending synchronous IO requests (from user threads rather than background threads) within InnoDB.
Pending WritesThe number of pending normal asynchronous IO write requests for data within InnoDB.
Reads Per SecThe average number of file reads per second within InnoDB for the snapshot interval.
Syncs Per SecThe average number of fsync() operations per second within InnoDB for the snapshot interval.
Writes Per SecThe average number of file writes per second within InnoDB for the snapshot interval.