Information Schema INNODB_BUFFER_POOL_STATS Table
You are viewing an old version of this article. View
the current version here.
The Information Schema INNODB_BUFFER_POOL_STATS table contains information about pages in the buffer pool, similar to what is returned with the SHOW ENGINE INNODB STATUS statement.
The PROCESS privilege is required to view the table.
It has the following columns:
| Column | Description |
|---|---|
| POOL_ID | ID of the buffer pool instance. |
| POOL_SIZE | Size in bytes of the buffer pool. |
| FREE_BUFFERS | |
| DATABASE_PAGES | Total number of pages in the buffer pool. |
| OLD_DATABASE_PAGES | Number of pages in the old sublist. |
| MODIFIED_DATABASE_PAGES | |
| PENDING_DECOMPRESS | |
| PENDING_READS | Pending buffer pool level reads. |
| PENDING_FLUSH_LRU | |
| PENDING_FLUSH_LIST | |
| PAGES_MADE_YOUNG | Pages moved from the old sublist to the new sublist. |
| PAGES_NOT_MADE_YOUNG | Pages that have remained in the old sublist without moving to the new sublist. |
| PAGES_MADE_YOUNG_RATE | Hits that cause blocks to move to the top of the new sublist. |
| PAGES_MADE_NOT_YOUNG_RATE | Hits that do not cause blocks to move to the top of the new sublist due to the innodb_old_blocks delay not being met. |
| NUMBER_PAGES_READ | Number of pages read. |
| NUMBER_PAGES_CREATED | Number of pages created. |
| NUMBER_PAGES_WRITTEN | Number of pages written. |
| PAGES_READ_RATE | |
| PAGES_CREATE_RATE | |
| PAGES_WRITTEN_RATE | |
| NUMBER_PAGES_GET | |
| HIT_RATE | |
| YOUNG_MAKE_PER_THOUSAND_GETS | |
| NOT_YOUNG_MAKE_PER_THOUSAND_GETS | |
| NUMBER_PAGES_READ_AHEAD | |
| NUMBER_READ_AHEAD_EVICTED | |
| READ_AHEAD_RATE | |
| READ_AHEAD_EVICTED_RATE | |
| LRU_IO_TOTAL | |
| LRU_IO_CURRENT | |
| UNCOMPRESS_TOTAL | |
| UNCOMPRESS_CURRENT |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
