https://bugzilla.wikimedia.org/show_bug.cgi?id=47045
--- Comment #3 from Sam Reed (reedy) <[email protected]> --- mysql:wikiadmin@db1017 [enwiki]> explain SELECT * FROM abuse_filter_log LEFT JOIN abuse_filter on (af_id=afl_filter) WHERE afl_user = 0 AND afl_user_text='90.221.128.138'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: abuse_filter_log type: ref possible_keys: afl_user key: afl_user key_len: 8 ref: const rows: 3959592 Extra: Using where *************************** 2. row *************************** id: 1 select_type: SIMPLE table: abuse_filter type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 8 ref: enwiki.abuse_filter_log.afl_filter rows: 1 Extra: 2 rows in set (0.02 sec) Running the query on enwiki (not going to paste results): 4 rows in set (47.63 sec) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
