Re: Can anyone help speed up this query?
The Match() calls don't appear to be increasing the mem load significantly, but they're costing time, did you try Øystein's suggestion?
> 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?
Subject
Views
Written By
Posted
1093
June 21, 2017 11:07AM
695
June 21, 2017 02:53PM
686
June 22, 2017 09:15AM
Re: Can anyone help speed up this query?
630
June 22, 2017 12:54PM
692
June 23, 2017 07:50AM
576
June 23, 2017 11:14AM
624
June 22, 2017 01:18AM
697
June 22, 2017 09:56AM
667
June 23, 2017 12:53AM
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.