Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?
Posted by: Cesar Murilo Cesar
Date: November 01, 2020 06:01AM

“When the size of the buffer pool is greater than 1 GB, setting innodb_buffer_pool_instances to a value greater than 1 can improve scalability on a busy server. (...) If innodb_buffer_pool_size is greater than 1.3 GB, the default for innodb_buffer_pool_instances is innodb_buffer_pool_size / 128 MB (...) On a dedicated database server, you can define the size of the buffer pool - (innodb_buffer_pool_size) - for 80% of the machine's physical memory size. ” source: shorturl.at/dopuJ

So if my Zabbix Server, a Slackware 14.2, has 16GB of RAM, it would have 12.8GB of innodb_buffer_pool_size and 100 innodb_buffer_pool_instances, correct?

Options: ReplyQuote




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.