content_image/692665.jpg content_image/692674.jpg content_image/692675.jpg
<img src='content_image/692665.jpg'>

Specifies that, on MySQL server startup, the InnoDB  buffer pool is automatically warmed up by loading the same pages it held at an earlier time. Typically used in combination with innodb_buffer_pool_dump_at_shutdown . 

Both innodb_buffer_pool_dump_at_shutdown  and innodb_buffer_pool_load_at_startup are enabled by default. 

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

• innodb_buffer_pool_load_now 

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

Immediately warms up the InnoDB  buffer pool by loading a set of data pages, without waiting for a server restart. Can be useful to bring cache memory back to a known state during benchmarking, or to ready the MySQL server to resume its normal workload after running queries for reports or maintenance. 

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

• innodb_buffer_pool_size 

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

The size in bytes of the buffer pool, the memory area where InnoDB  caches table and index data. The default value is 134217728 bytes (128MB). The maximum value depends on the CPU architecture; the maximum is 4294967295 (2$^{32}$-1) on 32-bit systems and 18446744073709551615 (2$^{64}$-1) on 64-bit systems. On 32-bit systems, the CPU architecture and operating system may impose a lower practical maximum size than the stated maximum. When the size of the buffer pool is greater than 1GB, setting 

