Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

[Peter Brawley]

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.