When configuring innodb_buffer_pool_chunk_size, the server will need to be restarted. The innodb_buffer_pool_chunk_size is best determined, by using a simple formula, and then rounding to the nearest 1MB:
Innodb_buffer_pool_chunk_size = Innodb_buffer_pool_size/innodb_bufffer_pool_instances Command Line: mysqld> set innodb_buffer_pool_chunk_size = XX
with value to suit your database needs. This change will only be applied to new connections. Make a new connection to the server and the values will update. SET GLOBAL will not persist through a server restart. Configuration File: [mysqld] innodb_buffer_pool_chunk_size = XX
with value to suit your database needs. Must restart MySQL server to see changes applied.