Buffer Pool Instances Doesn't Work
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.
Subject
Views
Written By
Posted
Buffer Pool Instances Doesn't Work
1053
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.