List:General Discussion« Previous MessageNext Message »
From:mysql Date:April 13 2006 7:07am
Subject:RE: Fulltext and reserved words
View as plain text  
If you are not rebuilding the FULLTEXT indexes, then that 
is probably why the change to the ft_min_word_len is not 
being recognised.

It seems like mysql uses this value to set the index it 
builds for the FULLTEXT search.

I don't know how to rebuild this index.

You may need to delete your .MYI file for the particular 
table (if this is where FULLTEXT indexes live) and then 
rebuild the .MYI file with myisamchk, or some other mysql 
utility.

Remember to make backups before experimenting on your 
db tables. Or copy them (as well) to a different directory, 
and do some tests on the copies first, untill you are sure what 
you are doing.

HTH

Keith

In theory, theory and practice are the same;
in practice they are not.

On Thu, 13 Apr 2006, Taco Fleur wrote:

> To: mysql@stripped, mysql@stripped
> From: Taco Fleur <taco.fleur@stripped>
> Subject: RE: Fulltext and reserved words
> 
> Hi,
> 
> I did everything but rebuild, I restarted the server but 
> the variable still has the same value. And I don't know 
> how to rebuild the table, I read the documentation, but I 
> guess I am just missing something there, like I have no 
> idea as a newbie where to enter those commands etc.
> 
> 
> Kind regards,
>  
> 
> Taco Fleur 
> 
> Free Call 1800 032 982 or Mobile 0421 851 786
> Pacific Fox http://www.pacificfox.com.au an industry leader with commercial
> IT experience since 1994 .
> 
> *	
> 	Web Design and Development 
> *	
> 	SMS Solutions, including developer API
> *	
> 	Domain Registration, .COM for as low as fifteen dollars a year,
> .COM.AU for fifty dollars two years!
> 
> 
> -----Original Message-----
> From: mysql@stripped [mailto:mysql@stripped] 
> Sent: Thursday, 13 April 2006 4:41 PM
> To: mysql@stripped
> Subject: RE: Fulltext and reserved words
> 
> Hi Taco - interesting thread.
> 
> Did you rebuilt the FullText indexes after restarting the server?
> 
> >From the 5.0.18 manual pages:
> 
> 12.7.5. Fine-Tuning MySQL Full-Text Search
> 
> <quote>
> Most full-text variables described in this section must be set at server
> startup time. A server restart is required to change them; they cannot be
> modified while the server is running. 
> 
> Some variable changes require that you rebuild the FULLTEXT indexes in your
> tables. Instructions for doing this are given at the end of this section. 
> 
> The minimum and maximum lengths of words to be indexed are defined by the
> ft_min_word_len and ft_max_word_len system variables. (See Section 5.2.2,
> Server System Variables.)
> 
> The default minimum value is four characters; the default maximum is version
> dependent. If you change either value, you must rebuild your FULLTEXT
> indexes.
> 
> For example, if you want three-character words to be searchable, you can set
> the ft_min_word_len variable by putting the following lines in an option
> file:
> 
> [mysqld]
> ft_min_word_len=3
> 
> Then you must restart the server and rebuild your FULLTEXT indexes. Note
> particularly the remarks regarding myisamchk in the instructions following
> this list. 
> </quote>
> 
> Regards
> 
> Keith
> 
> In theory, theory and practice are the same; in practice they are not.
> 
> On Thu, 13 Apr 2006, Taco Fleur wrote:
> 
> > To: mysql@stripped
> > From: Taco Fleur <taco.fleur@stripped>
> > Subject: RE: Fulltext and reserved words
> > 
> > Thanks for that, you saved the day. I am now trying to change that 
> > variable, I did a search through the ini files and changed the only 
> > file that had ft_min_word_len in it to ft_min_word_len = 2 restarted 
> > the server did SHOW VARIABLES and it still shows as 4, not sure what I 
> > am missing, going through the documentation but just can't find 
> > anything specific.
> > 
> > Kind regards,
> > 
> > Taco Fleur
Thread
Fulltext and reserved wordsTaco Fleur12 Apr
  • Re: Fulltext and reserved wordsDan Nelson12 Apr
RE: Fulltext and reserved wordsTaco Fleur13 Apr
  • RE: Fulltext and reserved wordsmysql13 Apr
RE: Fulltext and reserved wordsTaco Fleur13 Apr
  • RE: Fulltext and reserved wordsmysql13 Apr