https://bugzilla.wikimedia.org/show_bug.cgi?id=47722
Sam Reed (reedy) <s...@reedyboy.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|Unprioritized |Low
--- Comment #3 from Sam Reed (reedy) <s...@reedyboy.net> ---
mysql:wikiadmin@db1056 [enwiki]> EXPLAIN SELECT /* WikiPage::getContributors
192.168.0.18 */ rev_user AS user_id,rev_user_text AS
user_name,user_real_name,MAX(rev_timestamp) AS timestamp FROM `revision` LEFT
JOIN `user` ON ((rev_user = user_id)) WHERE rev_page = '1' AND (rev_user_text
!= '192.168.0.18') AND ((rev_deleted & 4) = 0) GROUP BY rev_user,rev_user_text
ORDER BY timestamp DESC\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: revision
type: ref
possible_keys: PRIMARY,page_timestamp,usertext_timestamp
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: user
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: enwiki.revision.rev_user
rows: 1
Extra:
2 rows in set (0.03 sec)
Main problem:
Extra: Using where; Using temporary; Using filesort
--
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
