How to Improve Performance of a MySQL Full-Text Search Query?

[Elis Jen]

Hello,

I'm working with a MySQL database containing a large articles table with columns article_id, title, content, and publish_date. I need to perform full-text searches on the title and content fields. Here’s my current query:

SELECT article_id, title, publish_date
FROM articles
WHERE MATCH(title, content) AGAINST('database optimization' IN NATURAL LANGUAGE MODE)
ORDER BY publish_date DESC;

The articles table has over five million rows, and the search performance is unsatisfactory despite having a full-text index on the title and content columns.

What additional strategies can improve the performance of full-text search queries in MySQL?

Thanks for your help!