https://bugzilla.wikimedia.org/show_bug.cgi?id=48873
--- Comment #6 from Sam Reed (reedy) <[email protected]> --- mysql:wikiadmin@db1058 [wikidatawiki]> explain SELECT cuc_namespace, cuc_title, cuc_user, cuc_user_text, cuc_comment, cuc_actiontext, cuc_timestamp, cuc_minor, cuc_page_id, cuc_type, cuc_this_oldid, cuc_last_oldid, cuc_ip, cuc_xff,cuc_agent FROM `cu_changes` FORCE INDEX (cuc_ip_hex_time) WHERE (cuc_ip_hex = '0A40007F') AND (1 = 1) ORDER BY cuc_timestamp DESC LIMIT 5001\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: cu_changes type: ref possible_keys: cuc_ip_hex_time key: cuc_ip_hex_time key_len: 258 ref: const rows: 1 Extra: Using where 1 row in set (0.00 sec) mysql:wikiadmin@db1058 [wikidatawiki]> explain SELECT cuc_user_text, cuc_timestamp, cuc_user, cuc_ip, cuc_agent, cuc_xff FROM `cu_changes` FORCE INDEX (cuc_ip_hex_time) WHERE (cuc_ip_hex = '0A40007F') AND (1 = 1) ORDER BY cuc_timestamp DESC LIMIT 10000\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: cu_changes type: ref possible_keys: cuc_ip_hex_time key: cuc_ip_hex_time key_len: 258 ref: const rows: 1 Extra: Using where 1 row in set (0.00 sec) -- 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
