InnoDB System Variables function. Each buffer pool manages its own free lists, flush lists, LRUs, and all other data structures connected to a buffer pool, and is protected by its own buffer pool mutex. This option only takes effect when setting  innodb_buffer_pool_size  to 1GB or more. The total buffer pool size is divided among all the buffer pools. For best efficiency, specify a combination of innodb_buffer_pool_instances  and  innodb_buffer_pool_size  so that each buffer pool instance is at least 1GB. The default value on 32-bit Windows systems depends on the value of  innodb_buffer_pool_size , as described below: On all other platforms, the default value is 8 when  innodb_buffer_pool_size  is greater than or equal to 1GB. Otherwise, the default is 1. For related information, see Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size” . Interrupts the process of restoring  InnoDB  buffer pool contents triggered by innodb_buffer_pool_load_at_startup  or  innodb_buffer_pool_load_now . For more information, see Section 15.8.3.6, “Saving and Restoring the Buffer Pool State” . 3225 Command-Line Format --innodb-buffer-pool-load-at- startup[={OFF|ON}] System Variable innodb_buffer_pool_load_at_startup Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean • innodb_buffer_pool_load_at_startup Command-Line Format --innodb-buffer-pool-load- abort[={OFF|ON}] System Variable innodb_buffer_pool_load_abort Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF • innodb_buffer_pool_load_abort •Otherwise, the default is 1. •If  innodb_buffer_pool_size  is greater than 1.3GB, the default for innodb_buffer_pool_instances  is  innodb_buffer_pool_size /128MB, with individual memory allocation requests for each chunk. 1.3GB was chosen as the boundary at which there is significant risk for 32-bit Windows to be unable to allocate the contiguous address space needed for a single buffer pool.