MySQL MATCH running very slow

Vote count:

0

I have a large table with about 60 million rows indexed with a fulltext index.

I am running the query below (for e.g) using Full Text search:

select * from text_file_data t where match( t.description_of_goods) against('+mobile' IN BOOLEAN MODE) order by t.id desc

These queries take forever to run, sometimes more than 10 minutes. This is running on a AWS m3.medium server (1 vCPU, 4 GB RAM).

How can I optimize to make this run faster ?

asked 53 secs ago

vkapadia

88

MySQL MATCH running very slow