MariaDB10.5.8全文索引引擎mroonga

# 安装全文索引引擎,支持中文
INSTALL SONAME 'ha_mroonga';
show engines;
# 创建表, 注意需要全文查词的字段为VARCHAR/CHAR/TEXT,且索引为FULLTEXT,ENGINE为MyISAM
CREATE TABLE `search` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	PRIMARY KEY (`id`),
	FULLTEXT INDEX `name` (`name`)
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=mroonga
AUTO_INCREMENT=3
;

# 进入mysql查看属性
show variables like 'ft%';

# 修正配置my.cnf文件[mysqld]增加
ft_min_word_len = 2
# 设置为空
ft_stopword_file = /home/jcleng/db-conf/db1stopword.txt
'',''
# 再次查看配置生效,为配置

# 修复
repair table search;

# 测试查询
SELECT * FROM search WHERE MATCH (name) AGAINST ('ss' IN BOOLEAN MODE);
SELECT * FROM search WHERE MATCH (name) AGAINST ('袜子 裤子' IN BOOLEAN MODE);