Hello all,

quick question. mysql defaults to a 4 character limit on full text searches. some of the keywords in my application are 3 characters so i'm going to change the configuration file and restart. i know that for the changes to take effect, i have to recreate all of my fulltext indexes.

my question is...if i change the configuration and reboot, will the already indexed tables at four characters break? e.g. will they still work? will it break anything if i don't reindex some of my indexes?

thanks...i hope this makes sense. i'm in a large production environment with way too many indexes to recreate without missing something...i just want to make sure they'll work the "old" way.

If you do not rebuild index you will not be abble to use 3 characters word in your request but FT index will still work.

Thanks! I have nothing to test it out on and am on a production environment. Just wanted to make sure.