Aaron Schulz has uploaded a new change for review. https://gerrit.wikimedia.org/r/282807
Change subject: Remove redundant UNIQUE from rev_page_id ...................................................................... Remove redundant UNIQUE from rev_page_id The PRIMARY KEY is rev_id, so this is a waste and makes the index slower to maintain (e.g. no change buffering). Change-Id: I63f817656ff5e62aa27caf607d70353cc99eb349 --- M maintenance/tables.sql 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core refs/changes/07/282807/1 diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 89aeb9c..b80d593 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -369,7 +369,7 @@ ) /*$wgDBTableOptions*/ 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 -CREATE UNIQUE INDEX /*i*/rev_page_id ON /*_*/revision (rev_page, rev_id); +CREATE INDEX /*i*/rev_page_id ON /*_*/revision (rev_page, rev_id); CREATE INDEX /*i*/rev_timestamp ON /*_*/revision (rev_timestamp); CREATE INDEX /*i*/page_timestamp ON /*_*/revision (rev_page,rev_timestamp); CREATE INDEX /*i*/user_timestamp ON /*_*/revision (rev_user,rev_timestamp); -- To view, visit https://gerrit.wikimedia.org/r/282807 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I63f817656ff5e62aa27caf607d70353cc99eb349 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/core Gerrit-Branch: master Gerrit-Owner: Aaron Schulz <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
