Yes I have verified whether the variable has changed with show variables,
and it has not changed as per my first email.
I have not gotten to rebuilding as the variable just will not change ;-)
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!
From: James Harvard [mailto:james.lists.tech@stripped]
Sent: Monday, 24 April 2006 10:11 PM
Subject: Re: Fulltext 3 letter words
You can find out whether the server has picked up the changes from your
configuration file by running the following SQL:
show variables like 'ft_min_word_len';
As per the instructions in the manual
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html you must
rebuild the indexes on any tables with a full-text index. Also, note the
warning about using myisamchk further down the manual page.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql