Header
MySQL - Set the minimum number of words for the FULLTEXT index
in: RDBMS  So/Code: Generico Data: 05/09/2013
Ora: 16.47:00
Articolo visualizzato: 5501 volte

By default a FULL TEXT index is created to perform a search with a minimum of 4 words, in some cases it is useful to be able to lower this limit but making good attention to performance.

The parameter to use is ft_min_word_len to be set in the configuration file of MySQL. Set this parameter to 4 below may invalidate performance, although in some cases it is necessary, especially in the back-end operations.

ft_min_word_len

Command-Line Format --ft_min_word_len=#
Option-File Format ft_min_word_len
System Variable Name ft_min_word_len
Variable Scope Global
Dynamic Variable No
  Permitted Values
Type numeric
Default 4
Min Value 1

The minimum length of the word to be included in a FULLTEXT index.

Note

FULLTEXT indexes must be rebuilt after changing this variable. Use REPAIR TABLE tbl_name QUICK.

It 's just need to set it to the desired value is to recreate the index.

Commenti Commenti (0) | User Autore: Guido Camerlingo (Guiz)
Tags: ft_min_word_len mysql fulltext search index full text index minimum word count





Articoli Correlati
MySQL - Set the minimum number of words for the FULLTEXT index
MySQL - Impostare il numero minimo di parole per l'indice FULLTEXT
[JAVA] Installare MySQL Java Connector su NetBeans
[MySQL] - Funzione REPLACE lo string replace di MySQL
[JAVA - NETBEANS] Connessione a MySQL (Java Connector JDBC)

Commenti

Scrivi Commento
Codice Verifica

Commento massimo 5000 caratteri.(Tutti i campi contrassegnati da * sono obbligatori).

   

Ricerca

Glossario Naviga nel nostro glossario!
Scopri il gergo dei Geek!


 ULTIMI ARTICOLI

226 giorni fa
447 giorni fa

 [EN] Last Articles

 Siti Amici

Visita il Blog Roll
Contattaci! Diventa nostro amico!



 Hot Downloads


 Categorie

85
163
58
87
13
2
20
36
1
2
5
5
128
7
24
15
62
45

 Code

11
11
3
6
2
24
1
7

 Games

19
45
13

 GUIDE


 Novità Downloads

70
68
3833

 Tags Cloud

Communications videogame Communications plus indagini network usa touch social indagini trasferimento foto iphone ifile



 CopyRight

Valid XHTML 1.0 Transitional CSS Valido! [Valid RSS] Creative Commons License


Geek-Blog by Flavio Mandato, Giuseppe Vaccaro, Guido Camerlingo, Stefano Natale, Domenico Cavallo is licensed under a Creative Commons Attribuzione-Non opere derivate 2.5 Italia License.
Based on a work at www.geek-blog.it.
Permissions beyond the scope of this license may be available at http://www.geek-blog.it/

Disclaimer - Responsabilità - Pagina generata in 0.090 secondi. Geek-Blog.it