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

RESOLVED FIXED in Bugzilla 2.18

Status

()

Bugzilla
Documentation
P2
normal
RESOLVED FIXED
15 years ago
5 years ago

People

(Reporter: myk, Assigned: Vlad Dascalu)

Tracking

unspecified
Bugzilla 2.18

Details

Attachments

(1 attachment, 2 obsolete attachments)

(Reporter)

Description

15 years ago
 
(Reporter)

Comment 2

15 years ago
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

Updated

15 years ago
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)

Comment 4

14 years ago
Created attachment 144725 [details] [diff] [review]
Add documentation in MySQL's configuration section.
(Assignee)

Updated

14 years ago
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-
(Assignee)

Comment 6

14 years ago
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.
(Assignee)

Comment 7

14 years ago
Created attachment 144735 [details] [diff] [review]
V2: Typos + improved v1
Attachment #144725 - Attachment is obsolete: true
(Assignee)

Comment 8

14 years ago
Created attachment 144737 [details] [diff] [review]
v3: removes set-variable which is not required per MySQL documentation
Attachment #144735 - Attachment is obsolete: true
(Assignee)

Comment 9

14 years ago
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
Last Resolved: 14 years ago
Resolution: --- → FIXED
(Assignee)

Updated

14 years ago
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

Comment 10

14 years ago
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.

Updated

13 years ago
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.