MySQL Forums
Forum List  »  Performance

Help in FullText Search Performance
Posted by: Deepa Balasubramanian
Date: July 07, 2022 09:00AM

We have a innodb table with 6 columns and about 1.2 million rows in it.
We have created a full text index on one of the column.

Our Server has 8GB Ram and 2CPU and running Mysql 8 Version in AWS Ec2 Ubuntu.

When i run the below query against the table, its taking about 4-5 secs to return about 150 matching rows.
But when i run for <3 words it returns in msec.
Please help to improve the query to return in msec or atleast 1-2 sec

I ran optimize table didint help ,inno db buffer size is also 75% and the table size is less than innodb buffersize and not many queries run in this server to compete for resources.


SELECT MATCH(idx.name) AGAINST ('"university of health sciences"' IN BOOLEAN MODE)+3000 as score
FROM test_org idx
WHERE MATCH(idx.name) AGAINST ('"university of health sciences"' IN BOOLEAN MODE)

Options: ReplyQuote


Subject
Views
Written By
Posted
Help in FullText Search Performance
39
July 07, 2022 09:00AM


Sorry, only registered users may post in this forum.

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.