MySQL Forums
Forum List  »  InnoDB

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment
Posted by: Authorized User
Date: September 13, 2021 08:10AM

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.

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.