10bet网址
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual

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 InnoDB缓冲池命中率页页意图d 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.