Send to Kindle
As we know, one of the most important config for InnoDB is the innodb_buffer_pool_size, it basically store the innodb data and indexes in memory, when MySQL receives a query and the InnoDB pages involved on that query are stored in the buffer, it does not need to go to the disk to return the result, which is much faster (memory speed vs disk speed).
As it is stored in memory, every time you restart your MySQL
server it starts with a clean/empty buffer pool and usually it
take some time to warm-up the buffer.
To speed up this process, we can configure 2 variables that will dump and reload the …