MySQL 全文检索设置停止词

MySQL 索引 全文检索 About 602 words

MyISAM 存储引擎

查看全文检索配置

SHOW VARIABLES LIKE 'ft%';

输出

Variable_name Value
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)

ft_stopword_fileMyISAM存储引擎的停止词配置文件

SET ft_stopword_file="/home/mysql/stopword.txt";

InnoDB 存储引擎

查看ngram如何标记文本

SET GLOBAL innodb_ft_aux_table="z-blog/post";

SELECT 
    *
FROM
    information_schema.innodb_ft_index_cache
ORDER BY doc_id , position;

参考文档

https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html#fulltext-stopwords-stopwords-for-myisam-search-indexes

Views: 2,988 · Posted: 2019-04-04

————        END        ————

Give me a Star, Thanks:)

https://github.com/fendoudebb/LiteNote

扫描下方二维码关注公众号和小程序↓↓↓

扫描下方二维码关注公众号和小程序↓↓↓


Today On History
Browsing Refresh