content_image/789435.jpg content_image/789436.jpg content_image/789437.jpg
• innodb_buffer_pool_dump_now 

<img src='content_image/789435.jpg'>

Immediately records the pages cached in the InnoDB  buffer pool. Typically used in combination with innodb_buffer_pool_load_now . 

For more information, see Section 15.8.3.6, “Saving and Restoring the Buffer Pool State” . 

• innodb_buffer_pool_dump_pct 

<img src='content_image/789436.jpg'>

Specifies the percentage of the most recently used pages for each buffer pool to read out and dump. The range is 1 to 100. The default value is 25. For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct  is set to 25, the 25 most recently used pages from each buffer pool are dumped. 

• innodb_buffer_pool_filename 

<img src='content_image/789437.jpg'>

Specifies the name of the file that holds the list of tablespace IDs and page IDs produced by innodb_buffer_pool_dump_at_shutdown  or innodb_buffer_pool_dump_now . Tablespace IDs and page IDs are saved in the following format: space, page_id . By default, the file is named 

