https://bugzilla.wikimedia.org/show_bug.cgi?id=69610
Bug ID: 69610
Summary: Improve perf of rolling active editors with dba's
suggestions
Product: Analytics
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Wikimetrics
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected]
Web browser: ---
Mobile Platform: ---
ELECT
anon_1.user_id AS anon_1_user_id,
IF(SUM(anon_1.count) >= 5, 1, 0) AS `IF_1`
FROM (
Note "order by null " and archive_userindex
SELECT
anon_2.user_id AS user_id,
anon_2.count AS count
FROM (
( SELECT
revision_userindex.rev_user AS user_id,
count(revision_userindex.rev_user) AS count
FROM revision_userindex
WHERE revision_userindex.rev_timestamp BETWEEN '20140716000000' AND
'20140815000000'
GROUP BY revision_userindex.rev_user
ORDER BY NULL)
UNION ALL
( SELECT
archive_userindex.ar_user AS user_id,
count(archive_userindex.ar_user) AS count
FROM archive_userindex
WHERE archive_userindex.ar_timestamp BETWEEN '20140716000000' AND
'20140815000000'
GROUP BY archive_userindex.ar_user
ORDER BY NULL)
) AS anon_2
) AS anon_1
GROUP BY anon_1.user_id
ORDER BY NULL;
--
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
