I have a modest 6GB database running in MySQL 8.0.x.. my dedicated server is only running 4 cores and 8GB RAM and it doesn't really have any major running issues.
after learning some very basic info about using the pool buffer last tomcat app upgrade and I after an initial stab i made a 1GB pool of 8 instances of the default 128m chunks.
my buffer is normally 78% full on these settings and i get a few read spikes and on a 15 minute delta I'm getting a 0.5 page read a second that is not in the buffer. i have the normal 4 read and 4 write Innodb threads (I would say my Db has 2/3 select heavy)
right to the actually question, i think i actually have another 1Gb that I can assign to my pool but i'm not sure which way to double it up.
Is it better to have bigger chunks (8/256Mb) or is it more beneficial to have more instances (16/128Mb)
Is there a query that can better indicate if I need more instances to hold more buffer, as my buffer still has some spare overhead, I assume i don't need bigger chunks? again its not running slow just want to make sure all is running as good as needed so I can leave it for a while.
Apologise if I'mm getting this completely wrong