mysql-5.7 saving and restore buffer pool state detailed

First, MySQL restart to face the problem :

Since the data cached in the InnoDB buffer pool is not available until after the reboot, MySQL will only be available from disk if business SQL arrives.

Read data into memory; it may take several hours for the data in memory to be business-intensive. Industry to put this memory from nothing

The process of thermal data in memory is called preheating . It can be seen that the performance of the database during the preheating process is not good, for memory (InnoDB buffer pool)

The larger the library warms up the longer it takes

second, the idea of solving the problem :

This solution is also simple and rude, the method is MySQL in the normal shutdown of the current in-memory page information (Tablespaceid,pageid), save to disk;

Wait until MySQL starts to load data from the disk into the InnoDB buffer pool based on the previously saved information;

Third, how to configure:

Before explaining the "solution to the problem", mentioned two process one is closed to save, a start-up recovery, the two processes each corresponding to a configuration

parameter, and a parameter is used to control the InnoDB buffer pool those pages to be "saved", "recovery" This is controlled by a percentage, this also

Corresponds to a parameter

[Mysqld] # --------InnoDB Buffer poolState innodb_buffer_pool_dump_pct                     =25                         #Innodb_buffer _pool_dump_at_shutdown             =on                         # Specifies whether to save information when the shutdown is started Innodb_buffer_pool_load_at_startup              =on                         # Specifies whether to enable this feature at startup

Iv. description of the innodb_buffer_pool_dump_pct:

The InnoDB buffer pool is internally organized by a list and configured to 25 that is, the 25% of the pages in front of the list to save their meta-information (Tablespaceid,pageid) when they are closed

This "front" refers to the new list in the InnoDB buffer pool; about the list of InnoDB buffer pool organization How can I see another blog

Http://www.cnblogs.com/JiangLe/p/7392421.html

　　　

----

Learning Communication

mysql-5.7 saving and restore buffer pool state detailed