InnoDB System Variables • innodb_buffer_pool_dump_now • innodb_buffer_pool_dump_pct • innodb_buffer_pool_filename 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 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. 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” . 3223 Command-Line Format --innodb-buffer-pool-dump-now[={OFF| ON}] System Variable innodb_buffer_pool_dump_now Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --innodb-buffer-pool-dump-pct=# System Variable innodb_buffer_pool_dump_pct Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 25 Minimum Value 1 Maximum Value 100 Command-Line Format --innodb-buffer-pool- filename=file_name System Variable innodb_buffer_pool_filename Scope Global Dynamic Yes SET_VAR  Hint Applies No Type File name Default Value ib_buffer_pool