From 151bd229726f9e248f23a79eb5215471a5945ca6 Mon Sep 17 00:00:00 2001 From: "jocuri%softhome.net" <> Date: Thu, 25 Mar 2004 19:19:00 +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/xml/installation.xml | 28 +++++++++++++++++++++++++--- 1 file changed, 25 insertions(+), 3 deletions(-) (limited to 'docs/xml') diff --git a/docs/xml/installation.xml b/docs/xml/installation.xml index 4ad915455..fde5ee764 100644 --- a/docs/xml/installation.xml +++ b/docs/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