Help in FullText Search Performance

[Deepa Balasubramanian]

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)