218206 - document ft_min_word_len MySQL param for indexing small words in full-text indexes

Status: RESOLVED FIXED

(Bugzilla :: Documentation, defect, P2)

Description

[Myk Melez [:myk] [@mykmelez]]

Comment 1

[Dave Miller [:justdave]]

uh, say what?

Comment 2

[Myk Melez [:myk] [@mykmelez]]

MySQL indexes only four+ character words by default in full-text indexes.  For
b.m.o at least this misses "cc", "ftp", "uri" and countless other two and three
character words that people want to search on regularly.

MySQL can be configured to index those words by setting the ft_min_word_len
param to the minimum size of words to index and rebuilding the indexes as
documented in the following page:

http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html

This information should be made available to Bugzilla administrators in the docs.

Comment 3

[Dave Miller [:justdave]]

Jake is leaving for a while (Reserve unit got called up), and we don't have a
new docs owner yet.  Anyone interested in helping out, please add
[e-mail] to your watch list in your email preferences in Bugzilla.

Comment 4

[Vlad Dascalu]

Attachment: Add documentation in MySQL's configuration section.

Comment 5

[Dave Miller [:justdave]]

Comment on attachment 144725 [details] [diff] [review]
Add documentation in MySQL's configuration section.

add a parameter where?	Should probably specify that you need to do it in
/etc/my.cnf like it does in 2.2.2.2.  On that note, the name of the config file
is misspelled in 2.2.2.2 :)  You can grab it with this if you want to save
getting another bug.  it's my.cnf not my.conf (no "o")

Comment 6

[Vlad Dascalu]

This should go in 2.18 only; full-search indexes weren't available in 2.16.

The typo in the 2.16 docs is fixed in bug 238610. I'll fix the typos in 2.18
within this bug.

Comment 7

[Vlad Dascalu]

Attachment: V2: Typos + improved v1

Comment 8

[Vlad Dascalu]

Attachment: v3: removes set-variable which is not required per MySQL documentation

Comment 9

[Vlad Dascalu]

Checking in docs/xml/installation.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/installation.xml,v  <-- 
installation.xml
new revision: 1.69; previous revision: 1.68
done

Comment 10

[Leigh Hunt]

It may be worth highlighting that the ft_min_word_len parameter is only 
available as of MySQL 4.0.0.

The MySQL subsection in the Installation section of the documentation states:
"You need MySQL version 3.23.41 or higher.", impying it will work with this 
version of mysql.