At 03:43 PM 9/14/2004, Mike Blezien wrote:
>mos wrote:
>>At 01:54 PM 9/14/2004, you wrote:
>>
>>>If I perform a fulltext search for 'foo', it won't match text like
>>>'foo, inc'.
>>>
>>>Why?
>>>
>>>Mysql 3.23.52
>>
>>Joe,
>> By default MySQL has a 4 letter minimum for fulltext searches;
>> words must be at least 4 letters in length otherwise they won't get
>> added. Since you are using MySQL 3.23, you will need to recompile the
>> binaries. With MySQL 4.x, you can simply change a variable in the
>> configuration file and rebuild the fulltext indexes.
>>Mike
>
>What variable setting is changed in the my.cnf, and is this under the
>mysqld group ??
>
>What is the proceedure to rebuild the FT indexes and the changes are made ??
>
>TIA
Mike,
See http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html.
Also see Attila Nagy's recommendation on using Drop Index/Build Index
rather than Repair Table.
Mike
