Re: Ram and buffer_pool_size question
Posted by: Peter Brawley
Date: July 20, 2022 12:10PM

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

Options: ReplyQuote

Written By
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.