From fd601e44bfdea5ed68450ff327801f7a2f685b9e Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Mon, 5 Feb 2007 09:13:36 +0000 Subject: [PATCH] In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit --- maintenance/tables.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 024675d4e4..28339f6c07 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -277,8 +277,8 @@ CREATE TABLE /*$wgDBprefix*/revision ( INDEX user_timestamp (rev_user,rev_timestamp), INDEX usertext_timestamp (rev_user_text,rev_timestamp) -) TYPE=InnoDB; - +) TYPE=InnoDB MAX_ROWS=10000000 AVG_ROW_LENGTH=1024; +-- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit -- -- Holds text of individual page revisions. @@ -313,7 +313,8 @@ CREATE TABLE /*$wgDBprefix*/text ( PRIMARY KEY old_id (old_id) -) TYPE=InnoDB; +) TYPE=InnoDB MAX_ROWS=10000000 AVG_ROW_LENGTH=10240; +-- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit -- -- Holding area for deleted articles, which may be viewed -- 2.20.1