question about innodb_buffer_pool_instances
Hi all,
i have a single-master DB replication Mysql 8.31, and i raised the "innodb_buffer_pool_size" parameter from 8 GB to 24 GB (Recommended InnoDB Buffer Pool Size select suggest 24) => RAM is 48 GB.
Should I also raise/adjust the parameter innodb_buffer_pool_instances or can i leave it like this? (now innodb_buffer_pool_instances=8 and innodb_buffer_pool_chunk_size=134217728).
Best Regards,
Nicola
Subject
Written By
Posted
question about innodb_buffer_pool_instances
February 13, 2023 06:37AM
February 13, 2023 12:02PM
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.