Re: Ram and buffer_pool_size question
Posted by: Peter Brawley
Date: July 20, 2022 06:31AM

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.

Options: ReplyQuote


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.