开发者

my stopwords list is loaded but not working

I have a modified stopwords list file, which basically took out the word 'alone'. I have updated m开发者_Go百科y /etc/my.cnf

ft_stopword_file=/etc/new_stopwords_list.txt

After restarting my mysql server, I did the following to show that mysql is indeed picking up the new variable.

SHOW VARIABLES LIKE '%ft_stop%'

+------------------+-----------------------------+
| Variable_name    | Value                       |
+------------------+-----------------------------+
| ft_stopword_file | /etc/new_stopwords_list.txt |
+------------------+-----------------------------+

Afterward, I did a REPAIR TABLE to update the index. However, when I do a search, the new setting does not seem to take effect. What am I doing wrong?


What mode are you using?. It could be because of the 50% threshold. Did you you check in this direction. http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜