Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

[Cesar Murilo Cesar]

Peter Brawley Wrote:
-------------------------------------------------------
> > it must be because there are only 8 instances.
>
> ?! Again, instances may affect concurrency
> performance, they are not a remedy for a
> too-small ib buffer. A warning "difficult to find
> free blocks in the buffer pool" suggests more RAM
> may be needed.
> .
> Your post says you're running MySQL 5.6, which is
> EOL in three months. Your log entry says you're
> running MariaDB 10.0, which has already passed its
> EOL date. Each successive MySQL version needs more
> RAM.
>
> If it's me, I upgrade to 8.0 then run diagnostics
> (eg "cheatsheet" at
> https://www.artfulsoftware.com/infotree/mysqltips.php)
> and calculate the growth rate to see how much RAM
> is needed now and how much is likely to be needed
> in the next year or two.
>
> And again, buffer pool instances are more relevant
> to concurrency---is that a current issue or not?


It is not a current problem.