Mysql5.6 buffer_pool preheating function

Usually after the MySQL restart service, you need to manually execute SQL to warm up the buffer_pool, in the mysql5.6, the following parameters can be used without manual intervention.

innodb_buffer_pool_dump_at_shutdown= 1: Dump hot data to local disk on shutdown Innodb_buffer_pool_dump_now = 1: Dump hot data to local disk manually InnoDB _buffer_pool_load_at_startup=1: Load hot data into memory at startup innodb_buffer_pool_load_now=1: Manually load hot data into memory only on normal shutdown or Pkill MySQL is the only place to export hot data.

Mysql5.6 buffer_pool preheating function