MySQL MATCH running very slow -
i have large table 60 million rows indexed fulltext index.
i running query below (for e.g) using full text search:
select * text_file_data t match( t.`description_of_goods`) against('+mobile' in boolean mode) order t.id desc
these queries take forever run, more 10 minutes. running on aws m3.medium server (1 vcpu, 4 gb ram).
how can optimize make run faster ?
Comments
Post a Comment