User "Aaron Schulz" posted a comment on MediaWiki.r97022.
Full URL: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97022#c22614
Commit summary:
Possible fix for issue reported in r83762. I had a hard time confirming the
problem/fix with profiling. Committing this now to get more attention.
Comment:
Here is the query now on my testwiki:
<pre>
SELECT /*! STRAIGHT_JOIN */ page_namespace,page_title,page_latest,fp_stable AS
stable,fp_quality AS quality,fp_pending_since AS pending_since,fp_pending_since
FROM `mw_flaggedpages` FORCE INDEX
(fp_pending_since),`mw_revision`,`mw_change_tag` FORCE INDEX
(change_tag_rev_tag),`mw_page` WHERE (fp_pending_since IS NOT NULL) AND
(rev_page = fp_page_id) AND (rev_id > fp_stable) AND (ct_rev_id = rev_id) AND
(page_id = fp_page_id) AND page_namespace IN ('0','6','10') GROUP BY
fp_pending_since,fp_page_id ORDER BY fp_pending_since,fp_page_id LIMIT 51
</pre>
This could also be tried with the fp_pending_since index changed to
fp_pending_since,fp_page_id.
_______________________________________________
MediaWiki-CodeReview mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-codereview
