MySQL full-text index minimum solution

Why should we use full-text indexes?

AverageDataLibrarySearchAll are usedSQLLike statement, like statement can not use the index, each query is from the first traversal to the last, the query efficiency is extremely low. Generally, if the data exceeds 0.1 million or the number of online users is too large, like queries will result inDatabaseCrash. This is why manyProgramOnly the title search is provided, because if the search content is slower, tens of thousands of data will not run.

MySQL full-text index is provided to Solve Fuzzy queries.ArticlePre-indexing by words, high search efficiency, and support million-level data retrieval.

If you are using your ownServer, Set it immediately. Do not waste this function.

If you are using a virtual host, please immediatelyContactThe Space Provider modifies the configuration. First, this default value of MySQL is an incorrect setting for Chinese characters. The modification is equal to correct the error. Second, the configuration modification is very simple, that is, a few minutes, and the improved search efficiency also reduces the chance of the Space Provider database downtime. If you send this article to a space provider, I believe most of them will be willing to change.

Setting method:

Modify my. ini (My. CnF in Linux), add a line "ft_min_word_len = 1" after [mysqld], restart MySQL, and run repair table table_name quick to recreate the index.