MySQL Forums
Forum List  »  Optimizer & Parser

Re: Can anyone help speed up this query?
Posted by: Search Team
Date: June 23, 2017 07:50AM


Peter Brawley Wrote:
> > Mem:      74374696   73947984     426712
> > Swap:     15999996     316024   15683972
> There's 75GB RAM yet near 16GB is swapping, yikes,
> swapping absolutely kills performance, must get
> rid of it. Have you tried
> innodb_buffer_pool_size=50G?

Correct me if I'm wrong, but I think you mis-read that.

The columns are total, used, free.

So at that moment, there was 316MB swapping. (I totally agree and understand that any swapping reduces performance.)

Also at that moment, there was only 426MB free physical RAM,
so increasing the innodb_buffer_pool_size by an additional 30GB would be bad, I think?

Options: ReplyQuote

Written By
Re: Can anyone help speed up this query?
June 23, 2017 07:50AM

Sorry, you can't reply to this topic. It has been closed.

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.