InnoDB Buffer Pool Configuration SET GLOBAL innodb_buffer_pool_dump_pct=40; [mysqld] innodb_buffer_pool_dump_pct=40 SET GLOBAL innodb_buffer_pool_dump_at_shutdown=ON; mysqld --innodb-buffer-pool-load-at-startup=ON; SET GLOBAL innodb_buffer_pool_dump_now=ON; SET GLOBAL innodb_buffer_pool_load_now=ON; SHOW STATUS LIKE ’Innodb_buffer_pool_dump_status’; SHOW STATUS LIKE ’Innodb_buffer_pool_load_status’; To abort a buffer pool load operation, issue the following statement: 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). 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). To display progress when saving the buffer pool state to disk, issue the following statement: To display progress when loading the buffer pool, issue the following statement: To restore the buffer pool state while MySQL is running, issue the following statement: To save the state of the buffer pool while MySQL server is running, issue the following statement: innodb_buffer_pool_load_at_startup  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: innodb_buffer_pool_dump_at_shutdown  is enabled by default. To save the state of the buffer pool at server shutdown, issue the following statement prior to shutting down the server: The  innodb_buffer_pool_dump_pct  default value is 25 (dump 25% of most-recently-used pages). If you plan to dump buffer pool pages at server shutdown, set  innodb_buffer_pool_dump_pct  in your configuration file. Saving the Buffer Pool State at Shutdown and Restoring it at Startup Saving and Restoring the Buffer Pool State Online Displaying Buffer Pool Dump Progress Displaying Buffer Pool Load Progress Aborting a Buffer Pool Load Operation 3121