From 5a135a8ef7433ccb6093116e9a106263c85996f8 Mon Sep 17 00:00:00 2001
From: "bugreport%peshkin.net" <>
Date: Wed, 28 Sep 2005 00:16:55 +0000
Subject: Bug 307602: Smooth attach_data upgrade for sites with huge attachment
 tables Patch by Joel Peshkin <bugreport@peshkin.net> r=mkanat, a=justdave

---
 Bugzilla/DB/Mysql.pm | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'Bugzilla/DB')

diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm
index c3824ab9a..952d49ff9 100644
--- a/Bugzilla/DB/Mysql.pm
+++ b/Bugzilla/DB/Mysql.pm
@@ -490,6 +490,16 @@ sub bz_setup_database {
                                {TYPE => 'DATETIME', NOTNULL => 1});
     }
 
+    # 2005-09-24 - bugreport@peshkin.net, bug 307602
+    # Make sure that default 4G table limit is overridden
+    my $row = $self->selectrow_hashref("SHOW TABLE STATUS LIKE 'attach_data'");
+    if ($$row{'Create_options'} !~ /MAX_ROWS/i) {
+        print "Converting attach_data maximum size to 100G...\n";
+        $self->do("ALTER TABLE attach_data
+                   AVG_ROW_LENGTH=1000000,
+                   MAX_ROWS=100000");
+    }
+
 }
 
 
-- 
cgit v1.2.3-24-g4f1b