MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT initialization 200s
Posted by: a a
Date: December 14, 2025 11:56AM

I found this issue when migrating servers in 2025/11. I migrated mysql to a server with almost the same configuration. The version is 5.7.44. There are some specific SQL sessions that are particularly long. However, this problem does not occur with the same data and the same SQL statement on other servers, and I tried to revert to 5.7.40 and still has this problem.
https://dba.stackexchange.com/questions/87089/full-text-search-results-in-a-large-amount-of-time-spent-in-fulltext-initializa
My question is almost the same. And all tried. There are still problems. The queried table has 1000w pieces of data.

For example, this one.
select id from problem WHERE MATCH (problem_text) AGAINST ('下面关于Android操作系统的描述中,正确的是' IN BOOLEAN MODE) and is_del = 0 limit 5;
FULLTEXT initialization has 200s. But when I switch to NATURAL LANGUAGE MODE, I don't have this problem. But NATURAL LANGUAGE MODE is too poor at matching short texts

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT initialization 200s
109
a a
December 14, 2025 11:56AM


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.