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
Created attachment 144725 [details] [diff] [review] Add documentation in MySQL's configuration section.
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 126.96.36.199. On that note, the name of the config file is misspelled in 188.8.131.52 :) 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.
Created attachment 144735 [details] [diff] [review] V2: Typos + improved v1
Attachment #144725 - Attachment is obsolete: true
Created attachment 144737 [details] [diff] [review] v3: removes set-variable which is not required per MySQL documentation
Attachment #144735 - 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
Last Resolved: 14 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.