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

Name	Description
Additional Alloc	The 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 Sec	The per second average number of InnoDB buffer pool pages created per second.
DB Pages	The total size in pages of the InnoDB buffer pool LRU list.
Dictionary Alloc	The total memory allocated for the InnoDB data dictionary in bytes.
Free Pages	The total size in pages of the InnoDB buffer pool free list.
Hit Rate	The InnoDB buffer pool page hit rate for pages read from the buffer pool memory vs from disk storage.
IO Cur Pages	The total number of InnoDB buffer pool LRU list pages accessed, for the last second.
IO Sum Pages	The total number of InnoDB buffer pool LRU list pages accessed, for the last 50 seconds.
IO Unzip Cur Pages	The total number of InnoDB buffer pool unzip_LRU list pages accessed, for the last second.
IO Unzip Sum Pages	The total number of Buffer Pool unzip_LRU list pages accessed, for the last 50 seconds.
Lru Len	The total size in pages of the InnoDB buffer pool LRU list.
Modified Pages	The current number of pages modified in the InnoDB buffer pool.
Not Young Hit Rate	The average rate at which InnoDB buffer pool pages have been made not young, for the past 15 seconds.
Old DB Pages	The 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 Sec	The 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 Sec	The 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 Sec	The 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 Sec	The 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 Sec	The per second average of the pages made young in the InnoDB buffer pool LRU list, for the last 15 seconds.
Pending Reads	The number of InnoDB buffer pool pages waiting to be read in to the buffer pool.
Pending Writes Flush List	The number of InnoDB buffer pool pages to be flushed during checkpointing.
Pending Writes Lru	The number of old dirty pages within the InnoDB buffer pool to be written from the bottom of the LRU list.
Pending Writes Single Page	The number of pending independent page writes within the InnoDB buffer pool.
Reads Per Sec	The per second average number of InnoDB buffer pool page reads per second.
Size Pages	The total size in pages allocated to the InnoDB buffer pool.
Total Alloc	The 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 Len	The total size in pages of the InnoDB buffer pool unzip_LRU list.
Written Per Sec	The per second average number of InnoDB buffer pool page writes per second.
Young Hit Rate	The average rate at which InnoDB buffer pool pages have been made young, for the past 15 seconds.