https://bugzilla.wikimedia.org/show_bug.cgi?id=17215
--- Comment #4 from Aryeh Gregor <[email protected]> 2009-01-29 16:50:03 UTC --- This is the explain I get on the toolserver: mysql> EXPLAIN SELECT rev_timestamp,page_namespace,page_title,rev_user_text,rc_patrolled FROM `page`,`revision` LEFT JOIN `recentchanges` ON ((rc_this_oldid=rev_id)) WHERE (page_id=rev_page) AND rev_deleted = '0' AND rev_user_text = 'Gurch' ORDER BY rev_user_text DESC, rev_timestamp DESC LIMIT 11; +----+-------------+---------------+--------+-------------------------------------------+--------------------+---------+--------------------------+---------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+--------+-------------------------------------------+--------------------+---------+--------------------------+---------+----------------------------------------------+ | 1 | SIMPLE | revision | ref | PRIMARY,page_timestamp,usertext_timestamp | usertext_timestamp | 257 | const | 187372 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | recentchanges | ALL | NULL | NULL | NULL | NULL | 6666524 | | | 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | enwiki.revision.rev_page | 1 | | +----+-------------+---------------+--------+-------------------------------------------+--------------------+---------+--------------------------+---------+----------------------------------------------+ 3 rows in set (0.01 sec) Note join type ALL, key NULL. I only have views on the toolserver, not the actual tables, so I can't try forcing rc_patrolling as the index to use for recentchanges there (nor can I use the FORCE INDEX that was already in the query). When I run it on localhost, it chooses rc_patrolling for the recentchanges join. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
