InnoDB Buffer Pool Configuration mysql>  SELECT @@innodb_buffer_pool_chunk_size; +---------------------------------+ | @@innodb_buffer_pool_chunk_size | +---------------------------------+ | 536870912 | +---------------------------------+ •Buffer pool size must always be equal to or a multiple of  innodb_buffer_pool_chunk_size *  innodb_buffer_pool_instances . If you alter  innodb_buffer_pool_chunk_size , innodb_buffer_pool_size  is automatically adjusted to a value that is equal to or a multiple of innodb_buffer_pool_chunk_size  *  innodb_buffer_pool_instances . The adjustment occurs when the buffer pool is initialized. This behavior is demonstrated in the following example: # The buffer pool has a default size of 128MB (134217728 bytes) mysql>  SELECT @@innodb_buffer_pool_size; +---------------------------+ | @@innodb_buffer_pool_size | +---------------------------+ | 134217728 | +---------------------------+ # The chunk size is also 128MB (134217728 bytes) mysql>  SELECT @@innodb_buffer_pool_chunk_size; +---------------------------------+ | @@innodb_buffer_pool_chunk_size | +---------------------------------+ | 134217728 | +---------------------------------+ # There is a single buffer pool instance mysql>  SELECT @@innodb_buffer_pool_instances; +--------------------------------+ | @@innodb_buffer_pool_instances | +--------------------------------+ | 1 | +--------------------------------+ # Chunk size is decreased by 1MB (1048576 bytes) at startup # (134217728 - 1048576 = 133169152): shell>  mysqld --innodb-buffer-pool-chunk-size=133169152 mysql>  SELECT @@innodb_buffer_pool_chunk_size; +---------------------------------+ | @@innodb_buffer_pool_chunk_size | +---------------------------------+ | 133169152 | +---------------------------------+ # Buffer pool size increases from 134217728 to 266338304 # Buffer pool size is automatically adjusted to a value that is equal to # or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances mysql>  SELECT @@innodb_buffer_pool_size; +---------------------------+ | @@innodb_buffer_pool_size | +---------------------------+ | 266338304 | +---------------------------+ This example demonstrates the same behavior but with multiple buffer pool instances: # The buffer pool has a default size of 2GB (2147483648 bytes) 3112