Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.