Re: Update of innodb_buffer_pool_instances
Hello Girish.
How are you?
Documentation for Innodb_buffer_pool_istances.
"This option only takes effect when setting innodb_buffer_pool_size to 1GB or more. The total buffer pool size is divided among all the buffer pools. For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1GB."
Your innodb_buffer_pool_size should generally be > 1 GB for is setting.
Read this link:
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_instances
Subject
Views
Written By
Posted
1240
May 05, 2025 11:15PM
Re: Update of innodb_buffer_pool_instances
65
March 22, 2026 04:13PM
Sorry, only registered users may post in this forum.
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.