MySQL-Innodb-Buffer Pool 运行时的参数

SHOW STATUS like '%innodb_buffer_pool%';

• Innodb_buffer_pool_dump_status
• Innodb_buffer_pool_load_status
• Innodb_buffer_pool_resize_status 触发动态调整大小的状态
• Innodb_buffer_pool_pages_data 包含数据的总页数（包括脏页和干净页）
• Innodb_buffer_pool_bytes_data 包含数据的总字节数（包括脏页和干净页）
• Innodb_buffer_pool_pages_dirty 脏页数
• Innodb_buffer_pool_bytes_dirty 脏页的总字节数
• Innodb_buffer_pool_pages_flushed 刷新页的请求数
• Innodb_buffer_pool_pages_free 可用页数
• Innodb_buffer_pool_pages_misc 繁忙的页数
• Innodb_buffer_pool_pages_total 总页数
• Innodb_buffer_pool_read_ahead_rnd 随机的预读次数（当查询随机顺序扫描大部分时会发生这种情况）
• Innodb_buffer_pool_read_ahead 预读进入到的页数
• Innodb_buffer_pool_read_ahead_evicted 预读被删除的页数
• Innodb_buffer_pool_read_requests 从缓存读的次数
• Innodb_buffer_pool_reads 从磁盘读的次数
• Innodb_buffer_pool_wait_free 没有干净页等待刷脏页的次数
• Innodb_buffer_pool_write_requests 写入缓存池的次数

SHOW ENGINE INNODB STATUS;

=====================================

2020-12-28 15:13:44 0x7f481b30c700 INNODB MONITOR OUTPUT

=====================================

Per second averages calculated from the last 45 seconds

----------------------

BUFFER POOL AND MEMORY

----------------------

Total large memory allocated 137428992 总大小

Dictionary memory allocated 3539530

Buffer pool size 8192 总页数

Free buffers 1024 空闲页

Database pages 7007 缓存页

Old database pages 2566 冷数据页数

Modified db pages 105 脏页

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 1234998, not young 63788318

2.49 youngs/s, 0.56 non-youngs/s

Pages read 1131122, created 21905, written 43518

0.09 reads/s, 0.00 creates/s, 6.00 writes/s

Buffer pool hit rate 1000 / 1000, young-making rate 7 / 1000 not 1 / 1000

Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s

LRU len: 7007, unzip_LRU len: 0

I/O sum[357]:cur[7], unzip sum[0]:cur[0]

----------------------------

END OF INNODB MONITOR OUTPUT

============================