InnoDB可以使用停用词文件吗? [英] Can InnoDB use a stopword file?

问题描述

通过全文搜索MyISAM，我知道可以使用以下命令在my.cnf中指定停用词文件:

With fulltext search for MyISAM, I know that I can specify a stopword file in my.cnf with the following:

ft_stopword_file = '/etc/stopword.txt'

对InnoDB进行全文本搜索也可以做到吗?如果可能的话，我想做类似以下的事情:

Can the same also be done with fulltext search for InnoDB? I'd like to do something like the following if possible:

ft_stopword_file_innodb = '/etc/stopword.txt'

但是，我还没有看到任何文档可以表明InnoDB的停用词可以存储在文件中.

However, I haven't seen any documentation indicating that stopwords for InnoDB can be stored in a file.

推荐答案

否，它不能以本地方式进行热线连接，即使用即开即用的文本文件.也就是mysql出厂.为此，您需要编写特殊的UDF，考虑到简单的解决方案，这是荒谬的.

No, it cannot natively, hotwired, use a text file out of the box. That is, mysql as shipped. To achieve that you would need to write speciality UDF's which would be absurd considering the simple solution.

有关自定义停用词用法的信息，可在此mysql 中找到.手册页.它显示了表INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD中有限的缺省字词，如何重设到自己的表以及各种系统变量的使用.

The information for custom Stop Words usage is available on this mysql manual page. It shows the rather limited default words out of the gates in the table INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD, how to reset to your own table, and the use of various system variables.

这篇关于InnoDB可以使用停用词文件吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！