https://bugzilla.wikimedia.org/show_bug.cgi?id=17215
--- Comment #5 from Roan Kattouw <[email protected]> 2009-01-29 17:33:00 UTC --- (In reply to comment #4) > 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). Why not? > When I run it on localhost, it chooses rc_patrolling for the > recentchanges join. > For me too, except that on one of my two computers, I don't *have* an rc_patrolling index, while on the other one I do. The index also isn't listed in tables.sql, and there's no updater patch that adds it. Where did my index go? :O :D Back on topic: maybe adding FORCE INDEX(rc_patrolling) will fix this, provided that index is present on the WMF DB servers. You also seem to indicate that the effect of this FORCE INDEX can't be tested on the toolserver for some reason. -- 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
