MarkTraceur has submitted this change and it was merged. Change subject: Add more robust specific user agent string ......................................................................
Add more robust specific user agent string Mingle: https://wikimedia.mingle.thoughtworks.com/projects/multimedia/cards/509 Change-Id: Ie33589fbeacf4bbb52cb8ffc61e5e66463b07ee0 --- M perf/mmv-versus-filepage.sql 1 file changed, 6 insertions(+), 6 deletions(-) Approvals: MarkTraceur: Verified; Looks good to me, approved diff --git a/perf/mmv-versus-filepage.sql b/perf/mmv-versus-filepage.sql index 22dd945..2b91153 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 AND userAgent LIKE '%Linux i686%' GROUP BY datestring ORDER BY datestring ASC) dates + FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE timestamp IS NOT NULL AND (userAgent LIKE '%Linux i686%' OR userAgent = 'MediaViewerE2ETest-Production') 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' AND userAgent LIKE '%Linux i686%' GROUP BY datestring ) file_page_stats USING (datestring) + FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type = 'file-page' AND (userAgent LIKE '%Linux i686%' OR userAgent = 'MediaViewerE2ETest-Production') 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 userAgent LIKE '%Linux i686%' 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%' OR userAgent = 'MediaViewerE2ETest-Production') 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 userAgent LIKE '%Linux i686%' 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%' OR userAgent = 'MediaViewerE2ETest-Production') 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 userAgent LIKE '%Linux i686%' 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%' OR userAgent = 'MediaViewerE2ETest-Production') 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 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 + FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type = 'mmv' AND (userAgent LIKE '%Linux i686%' OR userAgent = 'MediaViewerE2ETest-Production') 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/129566 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ie33589fbeacf4bbb52cb8ffc61e5e66463b07ee0 Gerrit-PatchSet: 1 Gerrit-Project: analytics/multimedia Gerrit-Branch: master Gerrit-Owner: MarkTraceur <[email protected]> Gerrit-Reviewer: Gilles <[email protected]> Gerrit-Reviewer: MarkTraceur <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
