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
938
June 21, 2017 11:07AM
582
June 21, 2017 02:53PM
579
June 22, 2017 09:15AM
Re: Can anyone help speed up this query?
566
June 22, 2017 12:54PM
574
June 23, 2017 07:50AM
471
June 23, 2017 11:14AM
554
June 22, 2017 01:18AM
604
June 22, 2017 09:56AM
589
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.