Re: Ram and buffer_pool_size question
> how many GB of ram I should have?
Depends on distribution of the load, and on how much of the server content is concurrently active. eg if 60% of your 100GB is the max ever concurrently active, am innodb_buffer_pool_size equal to that will let InnoDB run as an in-memory RDBMS. In that case you'd need 80GB. The cheatsheet will help answer that question.
Edited 1 time(s). Last edit at 07/20/2022 12:13PM by Peter Brawley.
Subject
Written By
Posted
Re: Ram and buffer_pool_size question
July 20, 2022 12:10PM
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.