From 2ed4b3245004cfa5de5e4b1ea3fcb9cab6c57c51 Mon Sep 17 00:00:00 2001 From: withoutaname Date: Mon, 4 Aug 2014 07:37:43 -0700 Subject: [PATCH] Change "ENGINE=HEAP" to "ENGINE=MEMORY" "Memory" is the preferred term, see https://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html Change-Id: I1fd05d027903af6023002dd357998ce5f2606708 --- maintenance/archives/patch-hitcounter.sql | 2 +- maintenance/archives/patch-profiling.sql | 2 +- maintenance/tables.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/maintenance/archives/patch-hitcounter.sql b/maintenance/archives/patch-hitcounter.sql index c87c9592e5..2d698f6865 100644 --- a/maintenance/archives/patch-hitcounter.sql +++ b/maintenance/archives/patch-hitcounter.sql @@ -6,4 +6,4 @@ CREATE TABLE /*$wgDBprefix*/hitcounter ( hc_id INTEGER UNSIGNED NOT NULL -) ENGINE=HEAP MAX_ROWS=25000; +) ENGINE=MEMORY MAX_ROWS=25000; diff --git a/maintenance/archives/patch-profiling.sql b/maintenance/archives/patch-profiling.sql index 0a0e4e1a58..6ad1622426 100644 --- a/maintenance/archives/patch-profiling.sql +++ b/maintenance/archives/patch-profiling.sql @@ -7,6 +7,6 @@ CREATE TABLE /*_*/profiling ( pf_memory float NOT NULL default 0, pf_name varchar(255) NOT NULL default '', pf_server varchar(30) NOT NULL default '' -) ENGINE=HEAP; +) ENGINE=MEMORY; CREATE UNIQUE INDEX /*i*/pf_name_server ON /*_*/profiling (pf_name, pf_server); \ No newline at end of file diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 4b9a5e22c1..f181e0fbdc 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -736,7 +736,7 @@ CREATE UNIQUE INDEX /*i*/ss_row_id ON /*_*/site_stats (ss_row_id); -- CREATE TABLE /*_*/hitcounter ( hc_id int unsigned NOT NULL -) ENGINE=HEAP MAX_ROWS=25000; +) ENGINE=MEMORY MAX_ROWS=25000; -- -- 2.20.1