From 0dcd5015f68535747aaf859da39601f8c14fce8b Mon Sep 17 00:00:00 2001 From: "jocuri%softhome.net" <> Date: Fri, 4 Apr 2008 11:46:59 +0000 Subject: Patch for bug 218206: document ft_min_word_len MySQL param for indexing small words in full-text indexes (and fix some typos while we're at it). --- docs/en/xml/installation.xml | 28 +++++++++++++++++++++++++--- 1 file changed, 25 insertions(+), 3 deletions(-) diff --git a/docs/en/xml/installation.xml b/docs/en/xml/installation.xml index d4c10ef07..c5f80721a 100644 --- a/docs/en/xml/installation.xml +++ b/docs/en/xml/installation.xml @@ -1,5 +1,5 @@ - + Installing Bugzilla @@ -565,7 +565,7 @@ If you run MySQL on the same machine as your web server, you should disable remote access to MySQL by adding - the following to your /etc/my.conf: + the following to your /etc/my.cnf: [myslqd] # Prevent network access to MySQL. @@ -597,7 +597,7 @@ You need to configure MySQL to accept large packets, if you want to have attachments larger than 64K. Add the text below to your - /etc/my.conf. + /etc/my.cnf. There is also a parameter in Bugzilla for setting the maximum allowable attachment size, (default 1MB). Bugzilla will only accept attachments up to the lower of these two @@ -609,6 +609,28 @@ set-variable = max_allowed_packet=1M +
+ Allow small words in full-text indexes + + By default, words must be at least four characters in length + in order to be indexed by MySQL's full-text indexes. This causes + a lot of Bugzilla specific words to be missed, including "cc", + "ftp" and "uri". + + MySQL can be configured to index those words by setting the + ft_min_word_len param to the minimum size of the words to index. + This can be done by modifying the /etc/my.cnf + according to the example below: + + [mysqld] + # Allow small words in full-text indexes + ft_min_word_len=2 + + Rebuilding the indexes can be done based on documentation found at + . + +
+
Permit attachments table to grow beyond 4GB By default, MySQL will limit the size of a table -- cgit v1.2.3-24-g4f1b