Hi Kevin,
some 10 days ago, Sean sent a nice heads up with sizes of EventLogging
tables and a question around purging of data (see below, and [1]).
I am reluctant to chime in there, as there was some talk about adding
EventLogging data purging to our Goals, and I do not want to interfere
with resourcing, or communication of Analytics Goals.
However, I cannot see you chiming in there.
If there is no buy-in or push-back from you by Friday, I consider it a
buy in, and start working towards at least trimming the biggest few
tables and having the necessary conversations around that.
Have fun,
Christian
[1] September part at:
https://lists.wikimedia.org/pipermail/analytics/2014-September/002519.html
October part at:
https://lists.wikimedia.org/pipermail/analytics/2014-October/002535.html
On Sun, Sep 28, 2014 at 04:02:39AM +1000, Sean Pringle wrote:
Hi :-)
These are the largest Eventlogging tables on m2-master:
145G MobileWebClickTracking_5929948.ibd
94G PageContentSaveComplete_5588433.ibd
61G MediaViewer_8572637.ibd
57G MediaViewer_8245578.ibd
30G MultimediaViewerNetworkPerformance_7917896.ibd
29G MediaViewer_8935662.ibd
24G MobileWikiAppToCInteraction_8461467.ibd
Are these sizes roughly expected?
Anything we can discard or reduce?
Where did the discussion on purging data end up?
No immediate problems here, just rattling cages :-)
BR
/s
--
DBA @ WMF
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics
--
---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ----
Companies' registry: 360296y in Linz
Christian Aistleitner
Kefermarkterstrasze 6a/3 Email: christian(a)quelltextlich.at
4293 Gutau, Austria Phone: +43 7946 / 20 5 81
Fax: +43 7946 / 20 5 81
Homepage:
http://quelltextlich.at/
---------------------------------------------------------------