Re: Can anyone help speed up this query?
To preserve text formatting, post text inside
BBCode [ code ] [ /code ] tags.
MySQL version? How much RAM is available to MySQL? Is there swapping? If these are innodb tables, what is innodb_buffer_pool_size?
Could we see the Explain result on the same query without the match() clauses?
Subject
Views
Written By
Posted
1419
June 21, 2017 11:07AM
Re: Can anyone help speed up this query?
895
June 21, 2017 02:53PM
899
June 22, 2017 09:15AM
851
June 22, 2017 12:54PM
863
June 23, 2017 07:50AM
796
June 23, 2017 11:14AM
834
June 22, 2017 01:18AM
896
June 22, 2017 09:56AM
866
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.