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: 5561 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

322 giorni fa
543 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
3842

 Tags Cloud

spam statistica carta here apple 4 numero 88% come numero firefox apple credito Mano sfondi statistica problema hd



 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.127 secondi. Geek-Blog.it