Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?
Posted by: Cesar Murilo Cesar
Date: November 02, 2020 09:58AM

The referenced link does not say 70%, do you think 80% of 16GB is a lot? In addition, she says: "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." That means that from 12G I would have 12 instances of 1GB, right? It is difficult to understand when one part of the documentation contradicts another, because as I mentioned before, there is an excerpt that says: "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". Another detail, I had said that I would have to define 100, because of this calculation, but the link you mentioned also says that the maximum is 64.

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.