MySQL Forums
Forum List  »  InnoDB

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

InnoDB requirements have margins, but that flexibility is limited.

Your architecture and hardware were set up eight years ago and you can't either change them or add RAM or servers for cost reasons? That's not a problem that tech support can help with.

If it's me and that's the case, and if I can't move this problem up the chain of command where it belongs, I turn on the mysql slow query log, identify the slow queries it reports, monitor swapping, add covering indexes for queries that the slow query log reports until swapping is eliminated, and report to the vendor poorly performing queries that you can't thus fix and that they therefore need to fix.

Obviously if the vendor does not cooperate with this, you've chosen your vendor badly.

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.