content_image/819147.jpg content_image/819145.jpg
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: 

•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. 

•Otherwise, the default is 1. 

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” . 

• innodb_buffer_pool_load_abort 

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

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” . 

• innodb_buffer_pool_load_at_startup 

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

