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