Oracle Enterprise Manager for MySQL Database
The InnoDB Buffer Pool page displays information on the InnoDB buffer pool usage on the monitored server.
Table 5.8 InnoDB Buffer Pool Performance Page Regions
Graph | Description |
---|---|
Buffer Usage | Graphs the amount of megabytes in the InnoDB buffer pool which contain data and the number of megabytes held in dirty pages. |
Row Requests | Graphs the number of logical read requests, logical read requests read from disk, and writes done to the buffer pool. |
Page Activity | Graphs the number of buffer pool pages read, written and created. |
Waits for Free Pages | Graphs the number of times writes to the buffer pool waited for clean pages to become available. |
Pages Flushed | Graphs the number of buffer pool page-flush requests. |
Pages Latched | Graphs the number of buffer pool pages latched. |
Young Page Activity | Graphs the number of pages made young and not young in the LRU list. |
Pending Operations | Graphs the number of pending reads, LRU writes, single-page writes and pages to be flushed during checkpointing. |
Page Read Ahead | Graphs the number of pages reads into the buffer pool by the read ahead thread and the number of pages evicted. |
Compression Time | Graphs the time, in seconds, spent compressing or uncompressing buffer pool pages. |
Current Usage | Pie chart which displays how the buffer pool is currently used. |
InnoDB Buffer Configuration | Lists the buffer-pool-specific system variables and their values. |