summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorvladd%bugzilla.org <>2008-04-04 13:47:51 +0200
committervladd%bugzilla.org <>2008-04-04 13:47:51 +0200
commitb907d6efb661bc92e2b916f8601142c546bed4af (patch)
treef5ce29b478f5b5f26250c888953cbdf6bfd71fa2
parentd03902400b2b9affff15ee56584607ea7aad92f3 (diff)
downloadbugzilla-b907d6efb661bc92e2b916f8601142c546bed4af.tar.gz
bugzilla-b907d6efb661bc92e2b916f8601142c546bed4af.tar.xz
Documentation patch for bug 314385: fine-tune the MySQL configuration instructions for allowing large attachments to be stored; patch by Colin Ogilvie <colin.ogilvie@gmail.com>, r=vladd.
-rw-r--r--docs/en/xml/installation.xml72
1 files changed, 38 insertions, 34 deletions
diff --git a/docs/en/xml/installation.xml b/docs/en/xml/installation.xml
index e5b3e4598..dda7dff3f 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.120 2008/04/04 06:47:50 uid623 Exp $ -->
+<!-- $Id: installation.xml,v 1.121 2008/04/04 06:47:51 vladd%bugzilla.org Exp $ -->
<chapter id="installing-bugzilla">
<title>Installing Bugzilla</title>
@@ -721,39 +721,6 @@
</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
- has no such limit. To set a higher limit, follow these
- instructions.
- </para>
-
- <para>
- Run the <filename>MySQL</filename> command-line client and
- enter:
- </para>
-
- <screen> <prompt>mysql&gt;</prompt> ALTER TABLE attachments
- AVG_ROW_LENGTH=1000000, MAX_ROWS=20000;
- </screen>
-
- <para>
- The above command will change the limit to 20GB. Mysql will have
- to make a temporary copy of your entire table to do this. Ideally,
- you should do this when your attachments table is still small.
- </para>
-
- <note>
- <para>
- This does not affect Big Files, attachments that are stored directly
- on disk instead of in the database.
- </para>
- </note>
- </section>
-
<section id="install-setupdatabase-adduser">
<title>Add a user to MySQL</title>
@@ -789,6 +756,43 @@
<prompt>mysql&gt;</prompt> FLUSH PRIVILEGES;</screen>
</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
+ has no such limit. To set a higher limit, follow these
+ instructions.
+ </para>
+
+ <para>
+ After you have completed the rest of the installation (or at least the
+ database setup parts), you should run the <filename>MySQL</filename>
+ command-line client and enter the following, replacing <literal>$bugs_db</literal>
+ with your Bugzilla database name (<emphasis>bugs</emphasis> by default):
+ </para>
+
+ <screen>
+ <prompt>mysql&gt;</prompt> use <replaceable>$bugs_db</replaceable>
+ <prompt>mysql&gt;</prompt> ALTER TABLE attachments
+ AVG_ROW_LENGTH=1000000, MAX_ROWS=20000;
+ </screen>
+
+ <para>
+ The above command will change the limit to 20GB. Mysql will have
+ to make a temporary copy of your entire table to do this. Ideally,
+ you should do this when your attachments table is still small.
+ </para>
+
+ <note>
+ <para>
+ This does not affect Big Files, attachments that are stored directly
+ on disk instead of in the database.
+ </para>
+ </note>
+ </section>
</section>
<section id="postgresql">