状态与手动操作
状态与手动操作
SHOW VARIABLES LIKE 'innodb_buffer_pool_dump%';
SHOW VARIABLES LIKE 'innodb_buffer_pool_load%';
SET GLOBAL innodb_buffer_pool_dump_now = ON;
SET GLOBAL innodb_buffer_pool_load_now = ON;
SHOW STATUS LIKE 'Innodb_buffer_pool_load_status';| dump | 默认 innodb_buffer_pool_dump_at_shutdown=ON |
|---|---|
| load | 默认 innodb_buffer_pool_load_at_startup=ON |
| 文件 | datadir/ib_buffer_pool 记录页号列表 |
切换/重启前手动 SET GLOBAL innodb_buffer_pool_dump_now=ON，可让恢复更快；预热是异步的，监控 load_status 再放流量。