Hi! On Jan 07, Jason Kushmaul wrote: > I have changed a fulltext variable ft_min_word_len from the default 4 to > 1, and the manual says to rebuild my fulltext indexes once again. > I verified that this variable changed with SHOW VARIABLES and it did change. > > I have tried optimize table, analyze table, repair table which all > finished without errors and very quickly, but When I try a new simple > query I can see that the index was not rebuilt. > I search for the word '+the*' which shows up in about every record. I > didn't get any records back earlier because my ft_min_word_len was too > high. but I still do not get any records. Does anyone know what I am > doing wrong?
Sorry, it's our fault. When the manual was written OPTIMIZE TABLE would be enough, since then it was optimized itself... Anyway, ALTER TABLE tablename TYPE=MyISAM; is enough. We'll update the manual. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php