https://bugzilla.wikimedia.org/show_bug.cgi?id=41283
--- Comment #2 from Sam Reed (reedy) <[email protected]> 2012-10-23 00:56:02 UTC --- mysql> explain SELECT gil_to,gil_wiki,gil_page,gil_page_namespace_id,gil_page_namespace,gil_page_title FROM `globalimagelinks` WHERE gil_to = 'Flag_of_France.svg' AND (gil_wiki != 'dewiki') ORDER BY gil_to ASC, gil_wiki ASC, gil_page ASC LIMIT 51\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: globalimagelinks type: range possible_keys: PRIMARY,globalimagelinks_wiki,globalimagelinks_wiki_nsid_title key: PRIMARY key_len: 291 ref: NULL rows: 1371752 Extra: Using where; Using filesort 1 row in set (0.00 sec) mysql> explain SELECT gil_to,gil_wiki,gil_page,gil_page_namespace_id,gil_page_namespace,gil_page_title FROM `globalimagelinks` WHERE gil_to = 'Flag_of_France.svg' AND (gil_wiki != 'dewiki') LIMIT 51\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: globalimagelinks type: range possible_keys: PRIMARY,globalimagelinks_wiki,globalimagelinks_wiki_nsid_title key: PRIMARY key_len: 291 ref: NULL rows: 1371752 Extra: Using where 1 row in set (0.00 sec) mysql> explain SELECT gil_to,gil_wiki,gil_page,gil_page_namespace_id,gil_page_namespace,gil_page_title FROM `globalimagelinks` WHERE gil_to = 'Flag_of_France.svg' AND (gil_wiki != 'dewiki') ORDER BY gil_to DESC, gil_wiki DESC, gil_page DESC LIMIT 51\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: globalimagelinks type: range possible_keys: PRIMARY,globalimagelinks_wiki,globalimagelinks_wiki_nsid_title key: PRIMARY key_len: 291 ref: NULL rows: 1371752 Extra: Using where; Using filesort 1 row in set (0.00 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
