From bfb9d464efa379d927c4a70e80a6e2939762decb Mon Sep 17 00:00:00 2001 From: "bugreport%peshkin.net" <> Date: Fri, 4 Apr 2008 11:46:55 +0000 Subject: Bug 228423: Document adjustment of MySQL 4GB default table size limit r=kiko, a=justdave --- docs/en/xml/installation.xml | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) (limited to 'docs') diff --git a/docs/en/xml/installation.xml b/docs/en/xml/installation.xml index 525f51e72..b7fa153ca 100644 --- a/docs/en/xml/installation.xml +++ b/docs/en/xml/installation.xml @@ -1,5 +1,5 @@ - + Installing Bugzilla @@ -608,6 +608,23 @@ # Allow packets up to 1M set-variable = max_allowed_packet=1M + +
+ Permit attachments table to grow beyond 4GB + 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. + Run the MySQL command-line client and + enter: + + mysql> ALTER TABLE attachments + AVG_ROW_LENGTH=1000000, MAX_ROWS=20000; + + 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. +
Add a user to MySQL -- cgit v1.2.3-24-g4f1b