Link You Today [Bookmark your Free, Libre software & tech link]

Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7

mariadb,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.

Link

Related Post