question about innodb_buffer_pool_instances
Posted by: nicola de amicis
Date: February 13, 2023 06:37AM

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,

Options: ReplyQuote

Written By
question about innodb_buffer_pool_instances
February 13, 2023 06:37AM

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.