MySQL Forums
Forum List  »  InnoDB

Buffer Pool Instances Doesn't Work
Posted by: Steven Cormier
Date: April 10, 2019 05:49PM

I have a new standalone Windows 10 installation. I've changed the buffer pool instances through

SET PERSIST innodb_buffer_pool_size = 8589934592; (8 Gb)
SET PERSIST_ONLY innodb_buffer_pool_instances = 16;

Default innodb_buffer_pool_chunk_size = 134217728 (128M)

When I restart, actual and persist values for innodb_buffer_pool_size are correct, while innodb_buffer_pool_instances persist value shows as 16 but actual value reported is 1.

As far as I can tell, the above values fit the rules for these settings of pool size divisable by chunk * instances. These are also the values in the MySQL 8 manual used as an example. I can't understand why it won't set the proper value for instances. There are no errors in the error log.

Options: ReplyQuote

Written By
Buffer Pool Instances Doesn't Work
April 10, 2019 05:49PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.