InnoDB System Variables Default Value ON 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” . 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” . 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 • innodb_buffer_pool_load_now • innodb_buffer_pool_size Command-Line Format --innodb-buffer-pool-load-now[={OFF| ON}] System Variable innodb_buffer_pool_load_now Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --innodb-buffer-pool-size=# System Variable innodb_buffer_pool_size Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 134217728 Minimum Value 5242880 Maximum Value (64-bit platforms) 2**64-1 Maximum Value (32-bit platforms) 2**32-1 3226