Re: Ram and buffer_pool_size question
Two approaches to this,
First, you need to run Explain (5.7) or Explain Analyze (8.0) on the slow queries and optimise their SQL and/or index use accordingly. If you get stuck with a query, post the Explain results here along with the query.
Second, for a 100 GB load, 8GB RAM may well be inadequate. To answer that question empirically, run the "Optimisation cheatsheet" described at
https://www.artfulsoftware.com/infotree/mysqltips.php and follow the suggestions it makes; again if you get stuck, post those results here inside BBCode code tags.
Subject
Written By
Posted
Re: Ram and buffer_pool_size question
July 20, 2022 06:31AM
Sorry, you can't reply to this topic. It has been closed.
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.