Home > Database > Mysql Tutorial > InnoDB全文索引停止词(stopwords)设计的缺陷

InnoDB全文索引停止词(stopwords)设计的缺陷

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:22:05
Original
1314 people have browsed it

全文索引FULLTEXT首次运用在了InnoDB引擎上,最近在研究过程中发现停止词(stopwords)设计的缺陷。何为停止词?就是指不想用户在搜索的时候能搜到‘李洪志大师

全文索引FULLTEXT首次运用在了InnoDB引擎上,最近在研究过程中发现停止词(stopwords)设计的缺陷。


何为停止词?就是指不想用户在搜索的时候能搜到‘李洪志大师’、‘法轮大法’等词汇,需要事先定义好停止词,这样就不会被搜索到。但设计的缺陷是,你必须事先就定义好,假如日后还想再定义停止词‘活摘器官’,必须重建一次全文索引,如果表很大的话,,相当耗费时间。


下面我们看例子,截图如下:

wKiom1NvF_uB4QbJAAEmgXqodfA422.jpg

wKioL1NvF9DQLImmAAJFAPzBHYk236.jpg

wKiom1NvF_vB-FptAAGBjuyN3H8363.jpg

结论:官方MySQL5.6.16和MariaDB10.0.10均有此缺陷,希望在后面的版本里,可以做调整。



本文出自 “贺春旸的技术专栏” 博客,请务必保留此出处

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template