Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Reston, VA
    Posts
    59

    Unanswered: Modifying Fulltext Indexing

    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.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    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.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Aug 2003
    Location
    Reston, VA
    Posts
    59
    Thanks! I have nothing to test it out on and am on a production environment. Just wanted to make sure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •