Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7mariadb,mysql,percona
In this blog post, I’ll discuss how to use the InnoDB buffer pool pre-load feature in MySQL 5.7.
Starting MySQL 5.6, you can configure MySQL to save the contents of your InnoDB buffer pool and load it on startup. Starting in MySQL 5.7, this is the default behavior. Without any special effort, MySQL saves and restores a portion of buffer pool in the default configuration.