r57026 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r57025‎ | r57026 | r57027 >
Date:21:15, 28 September 2009
Author:aaron
Status:ok
Tags:
Comment:
merged r56315
Modified paths:
  • /branches/wmf-deployment/extensions/FlaggedRevs/maintenance/updateStats.inc (modified) (history)

Diff [purge]

Index: branches/wmf-deployment/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('flaggedrevs' => 'PRIMARY','logging' => 'page_time')
 171+ 'USE INDEX' => array('page' => 'PRIMARY','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)),

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r56315force page index to be safeaaron17:47, 14 September 2009

Status & tagging log