I know the consensus seems to be approximately 75% of ram should be dedicated to the buffer pool. But, I'm more interested in the optimal number of buffer pool instances. What are some things to consider when determining the setting?
For example, let's say I have a 75GB buffer pool. Should I just assign 75 buffer pool instances at 1GB each? 15 at 5GB each? Or, 10 at 7.5GB each?
Should I start out with a single buffer pool and increase based on whether or not I see locking?
What should the max number of instances be based on – available cores?
Thanks – Your response is greatly appreciated.