Gilles has submitted this change and it was merged.
Change subject: Display performance stats over a long timespan
......................................................................
Display performance stats over a long timespan
90 days will give us better visibility about trends
Change-Id: I6155a0942488f3716dd1d54fe4d1e746bf74f837
---
M perf/template.sql
1 file changed, 6 insertions(+), 6 deletions(-)
Approvals:
Gilles: Verified; Looks good to me, approved
diff --git a/perf/template.sql b/perf/template.sql
index 191b230..93d7a0e 100644
--- a/perf/template.sql
+++ b/perf/template.sql
@@ -1,13 +1,13 @@
SET group_concat_max_len = 10485760;
SELECT * FROM (SELECT concat(substring(timestamp, 1, 4), '-',
substring(timestamp, 5, 2), '-', substring(timestamp, 7, 2)) AS datestring FROM
(
SELECT timestamp FROM MultimediaViewerNetworkPerformance_7917896
-WHERE timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY))
+WHERE timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 90 DAY))
UNION ALL
SELECT timestamp FROM MultimediaViewerNetworkPerformance_10596581
-WHERE timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY))
+WHERE timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 90 DAY))
UNION ALL
SELECT timestamp FROM MultimediaViewerNetworkPerformance_10774577
-WHERE timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY))
+WHERE timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 90 DAY))
) AS MultimediaViewerNetworkPerformanceUnioned GROUP BY datestring ORDER BY
datestring ASC) dates
LEFT OUTER JOIN
@@ -32,11 +32,11 @@
GROUP_CONCAT(event_total ORDER BY event_total SEPARATOR ','),
',', 99/100 * COUNT(*) + 1), ',', -1) AS DECIMAL) AS
%metricname%_time_99th_percentile FROM (
SELECT %metricfields% FROM MultimediaViewerNetworkPerformance_7917896
-WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) AND event_total > 20 AND
%metricwhere%
+WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 90 DAY)) AND event_total > 20 AND
%metricwhere%
UNION ALL
SELECT %metricfields% FROM MultimediaViewerNetworkPerformance_10596581
-WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) AND event_total > 20 AND
%metricwhere%
+WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 90 DAY)) AND event_total > 20 AND
%metricwhere%
UNION ALL
SELECT %metricfields% FROM MultimediaViewerNetworkPerformance_10774577
-WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) AND event_total > 20 AND
%metricwhere%
+WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND timestamp >=
TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 90 DAY)) AND event_total > 20 AND
%metricwhere%
) AS MultimediaViewerNetworkPerformanceUnioned GROUP BY datestring ORDER BY
datestring ASC ) stats USING (datestring)
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/187161
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I6155a0942488f3716dd1d54fe4d1e746bf74f837
Gerrit-PatchSet: 1
Gerrit-Project: analytics/multimedia
Gerrit-Branch: master
Gerrit-Owner: Gilles <gdu...@wikimedia.org>
Gerrit-Reviewer: Gilles <gdu...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
