MySQL Forums
Forum List  »  Full-Text Search

Re: 3 character search
Posted by: Erik Peterson
Date: March 01, 2012 08:00PM

I am installing Bugzilla 4.2, and the instructions state a similar step:

however, I am not sure with 'tbl' I am supposed to run this command on. Please advise.

Pg 11 -

2.2.2.2.2. Allow small words in full-text indexes
By default, words must be at least four characters in length in order to be indexed by MySQL’s full-text indexes. This
causes a lot of Bugzilla specific words to be missed, including "cc", "ftp" and "uri".
MySQL can be configured to index those words by setting the ft_min_word_len param to the minimum size of the
words to index. This can be done by modifying the /etc/my.cnf according to the example below:
[mysqld]
# Allow small words in full-text indexes
ft_min_word_len=2
Rebuilding the indexes can be done based on documentation found at http://www.mysql.com/doc/en/Fulltext_Finetuning.
html.

Options: ReplyQuote


Subject
Views
Written By
Posted
3556
February 07, 2012 03:52AM
2080
February 08, 2012 12:04AM
Re: 3 character search
2738
March 01, 2012 08:00PM
2096
March 03, 2012 11:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.