uh, say what?
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
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 firstname.lastname@example.org to your watch list in your email preferences in Bugzilla.
Assignee: jake → documentation
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 22.214.171.124. On that note, the name of the config file is misspelled in 126.96.36.199 :) 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.
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.
You need to log in before you can comment on or make changes to this bug.