The following articles mainly introduce the correct solution for the minimum value of MySQL full-text index. Do you have such questions about the actual solution for the minimum value of MySQL full-text index? Why must we use full-text indexes? The following articles will help you answer your questions.
In general, the like Statement of SQL is used for database search, and the like statement cannot use indexes. Each query goes from the first to the last one, and 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 may cause database crashes. This is why many programs only provide title search, because if the content is searched, it will be slower and tens of thousands of data will not run.
MySQL full-text index is designed to solve fuzzy queries. You can index the entire article by words in advance, which is highly efficient in search and supports retrieval of millions of data records.
If you are using your own server, set it immediately. Do not waste this function.
If you are using a virtual host, please immediately contact the Space Provider to modify 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 Linux to my. cnf), add "ft_min_word_len = 1" to the end of [MySQLd], restart MySQL, and run repair table table_name quick to recreate the index.
The above content is an introduction to the solution to the full-text index of MySQL. I hope you will find some gains.