diff options
| author | vladd%bugzilla.org <> | 2006-06-08 08:20:27 +0200 |
|---|---|---|
| committer | vladd%bugzilla.org <> | 2006-06-08 08:20:27 +0200 |
| commit | 086cc1c66a21e53f17cbad766d7f7cfeab2d7316 (patch) | |
| tree | 1a5650486e5ee584c5ef33cd7112b3ebd22c963d /docs | |
| parent | 5235c544da71c27467ad7f7f15a743c7bbe94110 (diff) | |
| download | bugzilla-086cc1c66a21e53f17cbad766d7f7cfeab2d7316.tar.gz bugzilla-086cc1c66a21e53f17cbad766d7f7cfeab2d7316.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.
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/xml/installation.xml | 72 |
1 files changed, 38 insertions, 34 deletions
diff --git a/docs/xml/installation.xml b/docs/xml/installation.xml index e2767e04e..743d67735 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.120 2006/06/06 15:54:30 uid623 Exp $ --> +<!-- $Id: installation.xml,v 1.121 2006/06/07 23:20:27 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></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></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></prompt> use <replaceable>$bugs_db</replaceable> + <prompt>mysql></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"> |