https://bugzilla.wikimedia.org/show_bug.cgi?id=47045
--- Comment #16 from Asher Feldman <afeld...@wikimedia.org> ---
I've added the user_timestamp index to enwiki, the original query is now fast:
mysql:wikiadmin@db1056 [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: user_timestamp
key: user_timestamp
key_len: 265
ref: const,const
rows: 4
Extra: Using index condition
*************************** 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: Using where
2 rows in set (0.03 sec)
Probably still missing on most other projects.
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
