系统表介绍
INNODB_BUFFER_POOL_STATS 描述了buffer pool的状态信息,其内容与结果 与 HOW ENGINE INNODB STATUS 命令相同
列名 | 含义 |
---|---|
POOL_ID | 池编号 |
POOL_SIZE | 池大小 |
FREE_BUFFERS | 空闲buffer数量 |
DATABASE_PAGES | buffer pool中包含数据的页数 |
OLD_DATABASE_PAGES | 在old buffer pool 中包含的块数量 |
MODIFIED_DATABASE_PAGES | 脏页数量 |
PENDING_DECOMPRESS | 等待解压缩 |
PENDING_READS | 读等待数量 |
PENDING_FLUSH_LRU | 在LRU列的表中等待刷新的页数量 |
PENDING_FLUSH_LIST | 在刷新列表中的等待刷新页数量 |
PAGES_MADE_YOUNG | 年轻页数量 |
PAGES_NOT_MADE_YOUNG | 非年轻页数量 |
PAGES_MADE_YOUNG_RATE | 每秒年轻页数量 |
PAGES_MADE_NOT_YOUNG_RATE | 每秒非年轻页数量 |
NUMBER_PAGES_READ | 读页数量 |
NUMBER_PAGES_CREATED | 创建页数量 |
NUMBER_PAGES_WRITTEN | 写页数量 |
PAGES_READ_RATE | 每秒读页数量 |
PAGES_CREATE_RATE | 每创建页数量 |
PAGES_WRITTEN_RATE | 每秒写页数量 |
NUMBER_PAGES_GET | 逻辑读请求数 |
HIT_RATE | 命中率 |
YOUNG_MAKE_PER_THOUSAND_GETS | 每1000次请求,年轻块的数量 |
NOT_YOUNG_MAKE_PER_THOUSAND_GETS | 每1000次请求,非年轻块的数量 |
NUMBER_PAGES_READ_AHEAD | 预读取页数量 |
NUMBER_READ_AHEAD_EVICTED | 无效预读取数量 |
READ_AHEAD_RATE | 每秒预读数量 |
READ_AHEAD_EVICTED_RATE | 每秒无效预读数量 |
LRU_IO_TOTAL | LRU石永红的IO |
LRU_IO_CURRENT | 当前LRU IO |
UNCOMPRESS_TOTAL | 解压缩总数 |
UNCOMPRESS_CURRENT | 当前解压缩数量 |
实例
mysql> select * from INNODB_BUFFER_POOL_STATS ;
+---------+-----------+--------------+----------------+--------------------+-------------------------+--------------------+---------------+-------------------+--------------------+------------------+----------------------+-----------------------+---------------------------+-------------------+----------------------+----------------------+-----------------+-------------------+--------------------+------------------+----------+------------------------------+----------------------------------+-------------------------+---------------------------+-----------------+-------------------------+--------------+----------------+------------------+--------------------+
| POOL_ID | POOL_SIZE | FREE_BUFFERS | DATABASE_PAGES | OLD_DATABASE_PAGES | MODIFIED_DATABASE_PAGES | PENDING_DECOMPRESS | PENDING_READS | PENDING_FLUSH_LRU | PENDING_FLUSH_LIST | PAGES_MADE_YOUNG | PAGES_NOT_MADE_YOUNG | PAGES_MADE_YOUNG_RATE | PAGES_MADE_NOT_YOUNG_RATE | NUMBER_PAGES_READ | NUMBER_PAGES_CREATED | NUMBER_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 |
+---------+-----------+--------------+----------------+--------------------+-------------------------+--------------------+---------------+-------------------+--------------------+------------------+----------------------+-----------------------+---------------------------+-------------------+----------------------+----------------------+-----------------+-------------------+--------------------+------------------+----------+------------------------------+----------------------------------+-------------------------+---------------------------+-----------------+-------------------------+--------------+----------------+------------------+--------------------+
| 0 | 8192 | 2199 | 5990 | 2191 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 254 | 5736 | 21667 | 0 | 0 | 0 | 26388239 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+---------+-----------+--------------+----------------+--------------------+-------------------------+--------------------+---------------+-------------------+--------------------+------------------+----------------------+-----------------------+---------------------------+-------------------+----------------------+----------------------+-----------------+-------------------+--------------------+------------------+----------+------------------------------+----------------------------------+-------------------------+---------------------------+-----------------+-------------------------+--------------+----------------+------------------+--------------------+
1 row in set (0.00 sec)