Oracle Enterprise Manager for MySQL Database

6.11 InnoDB Bufferpool Activity Metrics

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

Table 6.11 InnoDB Bufferpool Activity Metrics

NameDescription
Additional AllocThe total memory allocated for the InnoDB additional pool in bytes.
Compress Seconds (Delta)The total time in seconds spent compressing InnoDB buffer pool pages.
Created Per SecThe per second average number of InnoDB buffer pool pages created per second.
DB PagesThe total size in pages of the InnoDB buffer pool LRU list.
Dictionary AllocThe total memory allocated for the InnoDB data dictionary in bytes.
Free PagesThe total size in pages of the InnoDB buffer pool free list.
Hit RateThe InnoDB buffer pool page hit rate for pages read from the buffer pool memory vs from disk storage.
IO Cur PagesThe total number of InnoDB buffer pool LRU list pages accessed, for the last second.
IO Sum PagesThe total number of InnoDB buffer pool LRU list pages accessed, for the last 50 seconds.
IO Unzip Cur PagesThe total number of InnoDB buffer pool unzip_LRU list pages accessed, for the last second.
IO Unzip Sum PagesThe total number of Buffer Pool unzip_LRU list pages accessed, for the last 50 seconds.
Lru LenThe total size in pages of the InnoDB buffer pool LRU list.
Modified PagesThe current number of pages modified in the InnoDB buffer pool.
Not Young Hit RateThe average rate at which InnoDB buffer pool pages have been made not young, for the past 15 seconds.
Old DB PagesThe total size in pages of the InnoDB buffer pool old LRU list.
Pages Created (Delta)The total number of pages created within the InnoDB buffer pool.
Pages Evicted No Access Per SecThe per second average of the pages evicted without being accessed from the InnoDB buffer pool, for the last 15 seconds.
Pages Not Young (Delta)The total number of pages made not young in the InnoDB buffer pool LRU list.
Pages Not Young Per SecThe per second average of the pages made not young in the InnoDB buffer pool LRU list, for the last 15 seconds.
Pages Random Read Ahead Per SecThe per second average of random read ahead operations, for the last 15 seconds.
Pages Read (Delta)The total number of pages read from the InnoDB buffer pool.
Pages Read Ahead Per SecThe per second average of read ahead operations, for the last 15 seconds.
Pages Written (Delta)The total number of pages written from the InnoDB buffer pool.
Pages Young (Delta)The total number of pages made young in the InnoDB buffer pool LRU list.
Pages Young Per SecThe per second average of the pages made young in the InnoDB buffer pool LRU list, for the last 15 seconds.
Pending ReadsThe number of InnoDB buffer pool pages waiting to be read in to the buffer pool.
Pending Writes Flush ListThe number of InnoDB buffer pool pages to be flushed during checkpointing.
Pending Writes LruThe number of old dirty pages within the InnoDB buffer pool to be written from the bottom of the LRU list.
Pending Writes Single PageThe number of pending independent page writes within the InnoDB buffer pool.
Reads Per SecThe per second average number of InnoDB buffer pool page reads per second.
Size PagesThe total size in pages allocated to the InnoDB buffer pool.
Total AllocThe total memory allocated for the InnoDB buffer pool in bytes.
Uncompress Seconds (Delta)The total time in seconds spent uncompressing InnoDB buffer pool pages.
Unzip Lru LenThe total size in pages of the InnoDB buffer pool unzip_LRU list.
Written Per SecThe per second average number of InnoDB buffer pool page writes per second.
Young Hit RateThe average rate at which InnoDB buffer pool pages have been made young, for the past 15 seconds.


MySQL Documentation Library