elk mysql 全文索引_MySQL 全文索引实现简单版搜索引擎

参考https://www.cnblogs.com/YangJiaXin/p/11153579.html

mariadb 自定义分词无用

USE mysql;

CREATE TABLE my_stopwords(VALUE VARCHAR(30)) ENGINE = INNODB;

INSERT INTO my_stopwords(VALUE) VALUE (',');

SET GLOBAL innodb_ft_server_stopword_table = 'mysql/my_stopwords';

或者直接添加 my.cnf添加:

[mysqld]

innodb_ft_min_token_size=2

innodb_ft_server_stopword_table = 'mysql/my_stopwords';

-- 查看

SHOW GLOBAL VARIABLES WHERE Variable_name IN('innodb_ft_min_token_size','innodb_ft_server_stopword_table');

直接创建全文索引

alter table test_search add fulltext index idx_full_keyword(name);

explain SELECT FROM test_search where match(name) against('%反转%');

explain SELECT FROM test_search where match(name) against('哲理,悲剧' in boolean mode);