summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorbugreport%peshkin.net <>2004-03-20 14:51:43 +0100
committerbugreport%peshkin.net <>2004-03-20 14:51:43 +0100
commite6f6afded0637f910791dda714270b2766024793 (patch)
treeb1c1389c6555bbb6b6b8977082dac721ab1d7565
parentd9bcdba2ac385a91da5670bb33ca69711bdaaeda (diff)
downloadbugzilla-e6f6afded0637f910791dda714270b2766024793.tar.gz
bugzilla-e6f6afded0637f910791dda714270b2766024793.tar.xz
Bug 228423: Document adjustment of MySQL 4GB default table size limit
r=kiko, a=justdave
-rw-r--r--docs/xml/installation.xml19
1 files changed, 18 insertions, 1 deletions
diff --git a/docs/xml/installation.xml b/docs/xml/installation.xml
index 1000ef0cc..b0995ed53 100644
--- a/docs/xml/installation.xml
+++ b/docs/xml/installation.xml
@@ -1,5 +1,5 @@
<!-- <!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.1.2//EN"> -->
-<!-- $Id: installation.xml,v 1.64 2004/03/07 01:24:12 jocuri%softhome.net Exp $ -->
+<!-- $Id: installation.xml,v 1.65 2004/03/20 05:51:43 bugreport%peshkin.net Exp $ -->
<chapter id="installing-bugzilla">
<title>Installing Bugzilla</title>
@@ -608,6 +608,23 @@
# Allow packets up to 1M
set-variable = max_allowed_packet=1M</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 or if you are using RAID. 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>
+ </section>
<section id="install-setupdatabase-adduser">
<title>Add a user to MySQL</title>