Lokal Profil has uploaded a new change for review.
https://gerrit.wikimedia.org/r/324396
Change subject: [Blocked] Change DB engine to InnoDB
......................................................................
[Blocked] Change DB engine to InnoDB
Change the DB engine from MyISAM to InnoDB throughout. While this
is unlikely to be the root cause of our failing dumps it is still
a recommended change.
This is blocked by T123731#2779984
Bug: T138517
Change-Id: I3f92f2b004e3ca846d7013a5b90ae94960d72638
---
M api/includes/StatsBuilder.php
M erfgoedbot/monument_tables.py
M erfgoedbot/sql/create_table_admin_tree.sql
M erfgoedbot/sql/create_table_commonscat.sql
M erfgoedbot/sql/create_table_id_dump.sql
M erfgoedbot/sql/create_table_image.sql
M erfgoedbot/sql/fill_table_monuments_all.sql
M erfgoedbot/sql/fill_table_wlpa_all.sql
M prox_search/create_table_prox_search.sql
9 files changed, 9 insertions(+), 9 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/labs/tools/heritage
refs/changes/96/324396/1
diff --git a/api/includes/StatsBuilder.php b/api/includes/StatsBuilder.php
index c730415..0ac25dc 100644
--- a/api/includes/StatsBuilder.php
+++ b/api/includes/StatsBuilder.php
@@ -19,7 +19,7 @@
`idx` varchar(100) NOT NULL,
`value` varchar(16) NOT NULL DEFAULT '0',
PRIMARY KEY (`day`,`item`,`idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE monuments_all ADD INDEX idx_ctry_municp(country,municipality);
diff --git a/erfgoedbot/monument_tables.py b/erfgoedbot/monument_tables.py
index 693dd12..899a773 100755
--- a/erfgoedbot/monument_tables.py
+++ b/erfgoedbot/monument_tables.py
@@ -71,7 +71,7 @@
f.write(' PRIMARY KEY (`' + primkey.encode('utf8') + '`),\n')
f.write(' KEY `latitude` (`lat`),\n KEY `longitude` (`lon`)\n')
- f.write(') ENGINE=MyISAM DEFAULT CHARSET=utf8;\n')
+ f.write(') ENGINE=InnoDB DEFAULT CHARSET=utf8;\n')
f.close()
diff --git a/erfgoedbot/sql/create_table_admin_tree.sql
b/erfgoedbot/sql/create_table_admin_tree.sql
index 053c3b0..4a33fcf 100644
--- a/erfgoedbot/sql/create_table_admin_tree.sql
+++ b/erfgoedbot/sql/create_table_admin_tree.sql
@@ -6,4 +6,4 @@
`parent` INT,
KEY `parent` (`parent`),
KEY `level_name_lang` (`level`, `name`, `lang`)
-) ENGINE=INNODB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/erfgoedbot/sql/create_table_commonscat.sql
b/erfgoedbot/sql/create_table_commonscat.sql
index 5ebd058..2b6dde3 100644
--- a/erfgoedbot/sql/create_table_commonscat.sql
+++ b/erfgoedbot/sql/create_table_commonscat.sql
@@ -6,5 +6,5 @@
`commonscat` VARCHAR (255), -- Commons category into which files listed at
title should be categorised
`changed` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (site, title)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/erfgoedbot/sql/create_table_id_dump.sql
b/erfgoedbot/sql/create_table_id_dump.sql
index f158203..cea23f8 100644
--- a/erfgoedbot/sql/create_table_id_dump.sql
+++ b/erfgoedbot/sql/create_table_id_dump.sql
@@ -5,4 +5,4 @@
`country` varchar(10) binary NOT NULL DEFAULT '',
`lang` varchar(10) binary NOT NULL DEFAULT '',
`changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/erfgoedbot/sql/create_table_image.sql
b/erfgoedbot/sql/create_table_image.sql
index 5c4714b..ef14148 100644
--- a/erfgoedbot/sql/create_table_image.sql
+++ b/erfgoedbot/sql/create_table_image.sql
@@ -15,4 +15,4 @@
PRIMARY KEY (`country`,`id`, `img_name`),
KEY `country_id` (`country`,`id`),
KEY `img_name` (`img_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/erfgoedbot/sql/fill_table_monuments_all.sql
b/erfgoedbot/sql/fill_table_monuments_all.sql
index df2ff31..09abff6 100644
--- a/erfgoedbot/sql/fill_table_monuments_all.sql
+++ b/erfgoedbot/sql/fill_table_monuments_all.sql
@@ -45,7 +45,7 @@
KEY `name` (`name`),
KEY `coord` (`lat_int`,`lon_int`,`lat`),
FULLTEXT KEY `name_address_ft` (`name`, `address`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
TRUNCATE TABLE `monuments_all_tmp`;
diff --git a/erfgoedbot/sql/fill_table_wlpa_all.sql
b/erfgoedbot/sql/fill_table_wlpa_all.sql
index 64781a1..56447b3 100644
--- a/erfgoedbot/sql/fill_table_wlpa_all.sql
+++ b/erfgoedbot/sql/fill_table_wlpa_all.sql
@@ -48,7 +48,7 @@
KEY `creator` (`creator`),
KEY `coord` (`lat_int`,`lon_int`,`lat`),
FULLTEXT KEY `name_address_ft` (`name`, `address`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
TRUNCATE TABLE `wlpa_all_tmp`;
diff --git a/prox_search/create_table_prox_search.sql
b/prox_search/create_table_prox_search.sql
index cd333a0..455d9e8 100644
--- a/prox_search/create_table_prox_search.sql
+++ b/prox_search/create_table_prox_search.sql
@@ -18,4 +18,4 @@
INDEX peano1iv (int_peano1iv, point_id),
INDEX peano2iv (int_peano2iv, point_id)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
To view, visit https://gerrit.wikimedia.org/r/324396
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I3f92f2b004e3ca846d7013a5b90ae94960d72638
Gerrit-PatchSet: 1
Gerrit-Project: labs/tools/heritage
Gerrit-Branch: master
Gerrit-Owner: Lokal Profil <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
