http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97589
Revision: 97589
Author: asher
Date: 2011-09-20 00:51:05 +0000 (Tue, 20 Sep 2011)
Log Message:
-----------
disable fast index creation before creating new primary key w/IGNORE
Modified Paths:
--------------
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
Modified:
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
===================================================================
---
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
2011-09-20 00:30:32 UTC (rev 97588)
+++
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
2011-09-20 00:51:05 UTC (rev 97589)
@@ -4,7 +4,11 @@
DROP PRIMARY KEY;
-- Take the first row of any duplicates on new key
+-- Must disable fast index creation as a workaround to
+-- http://bugs.mysql.com/bug.php?id=40344
+set session old_alter_table=1;
ALTER IGNORE TABLE /*_*/flaggedrevs ADD PRIMARY KEY (fr_rev_id);
+set session old_alter_table=0;
CREATE INDEX /*i*/page_rev ON /*_*/flaggedrevs (fr_page_id,fr_rev_id);
CREATE INDEX /*i*/page_time ON /*_*/flaggedrevs (fr_page_id,fr_rev_timestamp);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
