r50117 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r50116‎ | r50117 | r50118 >
Date:06:19, 2 May 2009
Author:aaron
Status:ok
Tags:
Comment:
force index broken on new wikis due to index renaming of revision table
Modified paths:
  • /trunk/extensions/FlaggedRevs/maintenance/updateStats.inc (modified) (history)

Diff [purge]

Index: trunk/extensions/FlaggedRevs/maintenance/updateStats.inc
@@ -167,7 +167,7 @@
168168 'GROUP BY' => 'rev_id', // stats are for each edit and ID is unique
169169 'ORDER BY' => 'rev_id ASC', // slight bias avoidance, if any
170170 'LIMIT' => $size, // sample size
171 - 'USE INDEX' => array('revision' => array('PRIMARY','rev_id'),'flaggedrevs' => 'PRIMARY','logging' => 'page_time')
 171+ 'USE INDEX' => array('flaggedrevs' => 'PRIMARY','logging' => 'page_time')
172172 ),
173173 array( // Assumes title unchanged (reasonable). Double-check NS though.
174174 'page' => array('INNER JOIN',array('page_id = rev_page','page_namespace' => $wgFlaggedRevsNamespaces)),

Status & tagging log