From: Shawn Green Date: January 26 2010 5:28pm Subject: Re: impact of altering ft_min_word_len List-Archive: http://lists.mysql.com/mysql/220403 Message-Id: <4B5F2633.9000501@sun.com> MIME-Version: 1.0 Content-Type: text/plain; CHARSET=US-ASCII; format=flowed Content-Transfer-Encoding: 7BIT spikerlion@stripped wrote: > Hello, > > we want to set the global variable ft_min_word_len from the default "four" to the value "three". > > This is needed because we want to search for words with the max. length of three characters in one application. > > I've read that after setting ft_min_word_len to the new value, a "REPAIR TABLE QUICK;" is required. > > Now the question: > The MySQL holds more than one database but I only want to take affect the modification to one special database. Is there a problem with indizes in other databases or can I ensure that the affect only regards to one database? > > Regards > Spiker Once you change the Global setting, it affects all fulltext indexes. You will need to do the same REPAIR TABLE command on all tables currently using a fulltext index to keep the index and the setting in sync. Failure to do so can cause problems (crashes and corruptions) if you continue to use an index created with a different ft_min_word_len than the server currently has. -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN