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

RESOLVED FIXED in Bugzilla 2.18

Status

()

defect
P2
normal
RESOLVED FIXED
16 years ago
7 years ago

People

(Reporter: myk, Assigned: goobix)

Tracking

unspecified
Bugzilla 2.18
Dependency tree / graph

Details

Attachments

(1 attachment, 2 obsolete attachments)

 
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.
Summary: document ft_min → document ft_min_word_len MySQL param for indexing smaller words in full-text indexes
Priority: -- → P2
Target Milestone: --- → Bugzilla 2.18
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
documentation@bugzilla.org to your watch list in your email preferences in Bugzilla.
Assignee: jake → documentation
Assignee: documentation → vlad
Status: NEW → ASSIGNED
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")
Attachment #144725 - Flags: review-
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.
Posted patch V2: Typos + improved v1 (obsolete) — Splinter Review
Attachment #144725 - Attachment is obsolete: true
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
Status: ASSIGNED → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Summary: document ft_min_word_len MySQL param for indexing smaller words in full-text indexes → document ft_min_word_len MySQL param for indexing small words in full-text indexes
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.
Depends on: 266461
Blocks: 266461
No longer depends on: 266461
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.