MarkTraceur has uploaded a new change for review.
https://gerrit.wikimedia.org/r/129565
Change subject: Only show the data coming from cloudbees
......................................................................
Only show the data coming from cloudbees
Would be great if cloudbees had a patched/unique user agent
Change-Id: I58893e7a821f7489424d4d12647d2ac6b2ab2373
---
M perf/mmv-versus-filepage.sql
1 file changed, 6 insertions(+), 6 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia
refs/changes/65/129565/1
diff --git a/perf/mmv-versus-filepage.sql b/perf/mmv-versus-filepage.sql
index 5ff3981..22dd945 100644
--- a/perf/mmv-versus-filepage.sql
+++ b/perf/mmv-versus-filepage.sql
@@ -1,37 +1,37 @@
SELECT * FROM ( SELECT concat(substring(timestamp, 1, 4), '-',
substring(timestamp, 5, 2), '-', substring(timestamp, 7, 2)) AS datestring
- FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE timestamp
IS NOT NULL GROUP BY datestring ORDER BY datestring ASC) dates
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE timestamp
IS NOT NULL AND userAgent LIKE '%Linux i686%' GROUP BY datestring ORDER BY
datestring ASC) dates
LEFT OUTER JOIN
( SELECT concat(substring(timestamp, 1, 4), '-', substring(timestamp, 5, 2),
'-', substring(timestamp, 7, 2)) AS datestring,
AVG(event_duration) AS file_page_mean,
STD(event_duration) AS file_page_std
- FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'file-page' GROUP BY datestring ) file_page_stats USING (datestring)
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'file-page' AND userAgent LIKE '%Linux i686%' GROUP BY datestring )
file_page_stats USING (datestring)
LEFT OUTER JOIN
( SELECT concat(substring(timestamp, 1, 4), '-', substring(timestamp, 5, 2),
'-', substring(timestamp, 7, 2)) AS datestring,
AVG(event_duration) AS mmv_cold_mean,
STD(event_duration) AS mmv_cold_std
- FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND event_cache = 'cold' AND event_windowSize = 'average' GROUP BY
datestring ) mmv_cold_stats USING (datestring)
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND userAgent LIKE '%Linux i686%' AND event_cache = 'cold' AND
event_windowSize = 'average' GROUP BY datestring ) mmv_cold_stats USING
(datestring)
LEFT OUTER JOIN
( SELECT concat(substring(timestamp, 1, 4), '-', substring(timestamp, 5, 2),
'-', substring(timestamp, 7, 2)) AS datestring,
AVG(event_duration) AS mmv_warm_mean,
STD(event_duration) AS mmv_warm_std
- FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND event_cache = 'warm' AND event_windowSize = 'average' GROUP BY
datestring ) mmv_warm_stats USING (datestring)
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND userAgent LIKE '%Linux i686%' AND event_cache = 'warm' AND
event_windowSize = 'average' GROUP BY datestring ) mmv_warm_stats USING
(datestring)
LEFT OUTER JOIN
( SELECT concat(substring(timestamp, 1, 4), '-', substring(timestamp, 5, 2),
'-', substring(timestamp, 7, 2)) AS datestring,
AVG(event_duration) AS mmv_cold_large_mean,
STD(event_duration) AS mmv_cold_large_std
- FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND event_cache = 'cold' AND event_windowSize = 'large' GROUP BY
datestring ) mmv_cold_large_stats USING (datestring)
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND userAgent LIKE '%Linux i686%' AND event_cache = 'cold' AND
event_windowSize = 'large' GROUP BY datestring ) mmv_cold_large_stats USING
(datestring)
LEFT OUTER JOIN
( SELECT concat(substring(timestamp, 1, 4), '-', substring(timestamp, 5, 2),
'-', substring(timestamp, 7, 2)) AS datestring,
AVG(event_duration) AS mmv_warm_large_mean,
STD(event_duration) AS mmv_warm_large_std
- FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND event_cache = 'warm' AND event_windowSize = 'large' GROUP BY
datestring ) mmv_warm_large_stats USING (datestring)
\ No newline at end of file
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND userAgent LIKE '%Linux i686%' AND event_cache = 'warm' AND
event_windowSize = 'large' GROUP BY datestring ) mmv_warm_large_stats USING
(datestring)
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/129565
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I58893e7a821f7489424d4d12647d2ac6b2ab2373
Gerrit-PatchSet: 1
Gerrit-Project: analytics/multimedia
Gerrit-Branch: master
Gerrit-Owner: MarkTraceur <[email protected]>
Gerrit-Reviewer: Gilles <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
