1000万行.MySQLServerV.5.7有两个索引,分别称为"标语"和"体验".
此语句用时<;1秒:
SELECT count(*) FROM pa
WHERE MATCH(tagline) AGAINST('"developer"' IN BOOLEAN MODE);
此语句也用了<;1秒:
SELECT count(*) FROM pa
WHERE MATCH(experience) AGAINST('"python"' IN BOOLEAN MODE);
这条综合语句耗时30秒:
SELECT count(*) FROM pa
WHERE MATCH(tagline) AGAINST('"developer"' IN BOOLEAN MODE)
AND MATCH(experience) AGAINST('"python"' IN BOOLEAN MODE);
这里概述了类似的问题.从本质上说,对全文匹配做了一些细微的更改,使其毫无用处: https://medium.com/hackernoon/dont-waste-your-time-with-mysql-full-text-search-61f644a54dfa个