Gilles has uploaded a new change for review.
https://gerrit.wikimedia.org/r/170675
Change subject: Don't generate outdated versus graph anymore
......................................................................
Don't generate outdated versus graph anymore
Change-Id: I311ec633ef6dbb6dd9256c841c44b866e79893cc
---
M build-perf-tsvs
D perf/mmv-versus-filepage-new.sql
M perf/mmv-versus-filepage.sql
3 files changed, 6 insertions(+), 49 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia
refs/changes/75/170675/1
diff --git a/build-perf-tsvs b/build-perf-tsvs
index 345c8b3..5ed3a75 100755
--- a/build-perf-tsvs
+++ b/build-perf-tsvs
@@ -39,9 +39,3 @@
$MYSQL_CMD < $CHECKOUT_DIR/perf/mmv-versus-filepage.sql > $tsvpath && mv -f
$tsvpath $PUBLIC_DIR/media-viewer-perf-mmv-versus-filepage.tsv
chmod 664 $PUBLIC_DIR/media-viewer-perf-mmv-versus-filepage.tsv
echo " Done!"
-
-echo "Updating mmv-versus-filepage-new perf data..."
-tsvpath="$TSV_DIR/mvp_mmv_versus_filepage_new.tsv"
-$MYSQL_CMD < $CHECKOUT_DIR/perf/mmv-versus-filepage-new.sql > $tsvpath && mv
-f $tsvpath $PUBLIC_DIR/media-viewer-perf-mmv-versus-filepage-new.tsv
-chmod 664 $PUBLIC_DIR/media-viewer-perf-mmv-versus-filepage-new.tsv
-echo " Done!"
diff --git a/perf/mmv-versus-filepage-new.sql b/perf/mmv-versus-filepage-new.sql
deleted file mode 100644
index 47c3cca..0000000
--- a/perf/mmv-versus-filepage-new.sql
+++ /dev/null
@@ -1,37 +0,0 @@
-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 '%multimedia-perf%' 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 '%multimedia-perf%' 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 '%multimedia-perf%' 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 '%multimedia-perf%' 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 '%multimedia-perf%' 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 '%multimedia-perf%' AND event_cache = 'warm' AND
event_windowSize = 'large' GROUP BY datestring ) mmv_warm_large_stats USING
(datestring)
\ No newline at end of file
diff --git a/perf/mmv-versus-filepage.sql b/perf/mmv-versus-filepage.sql
index f7fa989..47c3cca 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%' OR userAgent LIKE
'%MediaViewerE2ETest-Production%') GROUP BY datestring ORDER BY datestring ASC)
dates
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE timestamp
IS NOT NULL AND userAgent LIKE '%multimedia-perf%' 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%' OR userAgent LIKE
'%MediaViewerE2ETest-Production%') GROUP BY datestring ) file_page_stats USING
(datestring)
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'file-page' AND userAgent LIKE '%multimedia-perf%' 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%' OR userAgent LIKE
'%MediaViewerE2ETest-Production%') 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 '%multimedia-perf%' 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%' OR userAgent LIKE
'%MediaViewerE2ETest-Production%') 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 '%multimedia-perf%' 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%' OR userAgent LIKE
'%MediaViewerE2ETest-Production%') 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 '%multimedia-perf%' 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%' OR userAgent LIKE
'%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
+ FROM MultimediaViewerVersusPageFilePerformance_7907636 WHERE event_type
= 'mmv' AND userAgent LIKE '%multimedia-perf%' 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/170675
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I311ec633ef6dbb6dd9256c841c44b866e79893cc
Gerrit-PatchSet: 1
Gerrit-Project: analytics/multimedia
Gerrit-Branch: master
Gerrit-Owner: Gilles <gdu...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
