InnoDB the defects of the full-text indexing stop word (stopwords) design

The full-text index fulltext was first used on the InnoDB engine, and recently found a flaw in the design of the Stop Word (stopwords) in the research process.

What is a stop word? It means that you do not want users to search for the "master Li Hongzhi", "Falun Dafa" and other words, need to define the stop words in advance, so it will not be searched. But the flaw in design is that you have to define it beforehand, and if you want to define the stop word ' living organ ' again in the future, you have to rebuild the full-text index, which is quite time-consuming if the table is large.

Let's look at the example below:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/26/ED/wKiom1NvF_uB4QbJAAEmgXqodfA422.jpg "style=" float: none; "title=" 1.jpg "alt=" Wkiom1nvf_ub4qbjaaemgxqodfa422.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/26/ED/wKioL1NvF9DQLImmAAJFAPzBHYk236.jpg "style=" float: none; "title=" 2.jpg "alt=" Wkiol1nvf9dqlimmaajfapzbhyk236.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/26/ED/wKiom1NvF_vB-FptAAGBjuyN3H8363.jpg "style=" float: none; "title=" 3.jpg "alt=" Wkiom1nvf_vb-fptaagbjuyn3h8363.jpg "/>

Conclusion: Both official MySQL5.6.16 and MariaDB10.0.10 have this flaw and hope that in later versions, adjustments can be made.

This article is from the "Spring Yang Technical column" blog, please be sure to keep this source http://hcymysql.blog.51cto.com/5223301/1409412