Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?
Posted by: Peter Brawley
Date: November 02, 2020 12:41PM

> 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?

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.