https://bugzilla.wikimedia.org/show_bug.cgi?id=47045
--- Comment #2 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'; +----+-------------+------------------+--------+---------------+----------+---------+------------------------------------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------------+--------+---------------+----------+---------+------------------------------------+---------+-------------+ | 1 | SIMPLE | abuse_filter_log | ref | afl_user | afl_user | 8 | const | 3893344 | Using where | | 1 | SIMPLE | abuse_filter | eq_ref | PRIMARY | PRIMARY | 8 | enwiki.abuse_filter_log.afl_filter | 1 | | +----+-------------+------------------+--------+---------------+----------+---------+------------------------------------+---------+-------------+ 2 rows in set (0.06 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
