The way of MySQL Management-Notes-InnoDB Buffer Pool preheating improvement
Improvement of InnoDB Buffer Pool preheating
Improvement of InnoDB Buffer Pool preheating
Only MySQL5.7 and Percona5.7 are supported
When the database is restarted, how to load the previously frequently accessed data back into BUFFER?
MySQL5.6/MariaDB 10.0, new feature to quickly preheat Buffer_Pool buffer pool
Add to my.cnf:
Dump the hot data to the local hard disk when off
Innodb_buffer_pool_dump_at_shutdown = 1
Manually dump the hot data to the local hard disk
Innodb_buffer_pool_dump_now = 1
Load hot data into memory at startup
Innodb_buffer_pool_load_at_startup = 1
Load hot data into memory manually
Innodb_buffer_pool_load_now = 1
