summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
diff options
context:
space:
mode:
authorbugreport%peshkin.net <>2005-09-28 02:16:55 +0200
committerbugreport%peshkin.net <>2005-09-28 02:16:55 +0200
commit5a135a8ef7433ccb6093116e9a106263c85996f8 (patch)
treef60414d61fcc8c03120c108d5706e24d347d6afd /Bugzilla/DB
parentb56d5f6c828c6276449bc57bb31a00cebb592036 (diff)
downloadbugzilla-5a135a8ef7433ccb6093116e9a106263c85996f8.tar.gz
bugzilla-5a135a8ef7433ccb6093116e9a106263c85996f8.tar.xz
Bug 307602: Smooth attach_data upgrade for sites with huge attachment tables
Patch by Joel Peshkin <bugreport@peshkin.net> r=mkanat, a=justdave
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r--Bugzilla/DB/Mysql.pm10
1 files changed, 10 insertions, 0 deletions
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");
+ }
+
}