MySQL Variables ft_stopword_file 数据库 参数变量解释及正确配置使用

本站中文解释

ft_stopword_file是MySQL的一个全文检索参数变量，其用途是用来设定全文检索时需要忽略的停用词文件名。

要设置该参数，可以使用MySQL命令行工具：

mysql> set global ft_stopword_file = ‘/path/to/stopword_file’;

官方英文解释

ft_stopword_file

The file from which to read the list of stopwords for
full-text searches on MyISAM tables. The
server looks for the file in the data directory unless an
absolute path name is given to specify a different directory.
All the words from the file are used; comments are
not honored. By default, a built-in list
of stopwords is used (as defined in the
storage/myisam/ft_static.c file). Setting
this variable to the empty string ('')
disables stopword filtering. See also
Section 12.10.4, “Full-Text Stopwords”.