summaryrefslogtreecommitdiffstats
path: root/docs
diff options
context:
space:
mode:
authorjocuri%softhome.net <>2008-04-04 13:46:59 +0200
committerjocuri%softhome.net <>2008-04-04 13:46:59 +0200
commit0dcd5015f68535747aaf859da39601f8c14fce8b (patch)
tree93c912886c224a82f5c6cb69eb03898b3ae7d437 /docs
parent1b443cacd3bba5209d6b5d80081aeeba7fbdfb6f (diff)
downloadbugzilla-0dcd5015f68535747aaf859da39601f8c14fce8b.tar.gz
bugzilla-0dcd5015f68535747aaf859da39601f8c14fce8b.tar.xz
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).
Diffstat (limited to 'docs')
-rw-r--r--docs/en/xml/installation.xml28
1 files 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 @@
<!-- <!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.1.2//EN"> -->
-<!-- $Id: installation.xml,v 1.68 2008/04/04 06:46:58 bugreport%peshkin.net Exp $ -->
+<!-- $Id: installation.xml,v 1.69 2008/04/04 06:46:59 jocuri%softhome.net Exp $ -->
<chapter id="installing-bugzilla">
<title>Installing Bugzilla</title>
@@ -565,7 +565,7 @@
<listitem>
<para>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 <filename>/etc/my.conf</filename>:
+ the following to your <filename>/etc/my.cnf</filename>:
</para>
<programlisting> [myslqd]
# Prevent network access to MySQL.
@@ -597,7 +597,7 @@
<para>You need to configure MySQL to accept large packets, if you
want to have attachments larger than 64K. Add the text
below to your
- <filename>/etc/my.conf</filename>.
+ <filename>/etc/my.cnf</filename>.
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
@@ -610,6 +610,28 @@
</section>
<section>
+ <title>Allow small words in full-text indexes</title>
+
+ <para>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".</para>
+
+ <para>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 <filename>/etc/my.cnf</filename>
+ according to the example below:</para>
+
+ <screen> [mysqld]
+ # Allow small words in full-text indexes
+ ft_min_word_len=2</screen>
+
+ <para>Rebuilding the indexes can be done based on documentation found at
+ <ulink url="http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html"/>.
+ </para>
+ </section>
+
+ <section>
<title>Permit attachments table to grow beyond 4GB</title>
<para>By default, MySQL will limit the size of a table
to 4GB. This limit is present even if the underlying filesystem