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

[Authorized User]

Peter Brawley Wrote:
-------------------------------------------------------
> 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.

No, this is a new project. New server. New load requirements. What I said was that the vendor standardized on InnoDB 8 years ago.

No worries, I'll do my own experimentation. I will take a snapshot of a representative database and then turn on general query logging to capture a full day of real user activity consisting of a million or so queries.

I will spin up a MySQL instance on the new server using the database snapshot and then experiment with various configurations and settings by playing the general log file into the test instance. Rinse, repeat. I'll see which configurations finish the file the fastest and eventually arrive at the best solution to our problem.