SET GLOBAL innodb_buffer_pool_dump_pct=40; 

If you plan to dump buffer pool pages at server shutdown, set innodb_buffer_pool_dump_pct  in your configuration file. 

[mysqld] innodb_buffer_pool_dump_pct=40 

The innodb_buffer_pool_dump_pct  default value is 25 (dump 25% of most-recently-used pages). 

## Saving the Buffer Pool State at Shutdown and Restoring it at Startup 

To save the state of the buffer pool at server shutdown, issue the following statement prior to shutting down the server: 

SET GLOBAL innodb_buffer_pool_dump_at_shutdown=ON; 

innodb_buffer_pool_dump_at_shutdown  is enabled by default. 

To restore the buffer pool state at server startup, specify the --innodb-buffer-pool-load-at- startup  option when starting the server: 

## Saving and Restoring the Buffer Pool State Online 

mysqld --innodb-buffer-pool-load-at-startup=ON; 

innodb_buffer_pool_load_at_startup  is enabled by default. 

To save the state of the buffer pool while MySQL server is running, issue the following statement: 

SET GLOBAL innodb_buffer_pool_dump_now=ON; 

To restore the buffer pool state while MySQL is running, issue the following statement: 

## Displaying Buffer Pool Dump Progress 

SET GLOBAL innodb_buffer_pool_load_now=ON; 

To display progress when saving the buffer pool state to disk, issue the following statement: 

SHOW STATUS LIKE ’Innodb_buffer_pool_dump_status’; 

If the operation has not yet started, “not started”  is returned. If the operation is complete, the completion time is printed (e.g. Finished at 110505 12:18:02). If the operation is in progress, status information is provided (e.g. Dumping buffer pool 5/7, page 237/2873). 

## Displaying Buffer Pool Load Progress 

To display progress when loading the buffer pool, issue the following statement: 

SHOW STATUS LIKE ’Innodb_buffer_pool_load_status’; 

If the operation has not yet started, “not started”  is returned. If the operation is complete, the completion time is printed (e.g. Finished at 110505 12:23:24). If the operation is in progress, status information is provided (e.g. Loaded 123/22301 pages). 

## Aborting a Buffer Pool Load Operation 

To abort a buffer pool load operation, issue the following statement: 

