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

[Peter Brawley]

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.