Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?
Posted by: Cesar Murilo Cesar
Date: November 02, 2020 01:50PM

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.

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.