MySQL Forums
Forum List  »  InnoDB

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment
Posted by: Peter Brawley
Date: September 09, 2021 01:57PM

Leaving aside that ummerited slagging of InnoDB, your question puts the cart (of RAM available) before the horse (of requirements) ... that is, a sounder approach determines what the software needs, then configures hardware to match that requirement.

InnoDB runs best when the buffer pool is big enough to allow it to run entirely in memory. I don't know an alternative way to achieve equivalent performance.

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.