Hi Kevin,
thanks for chiming in!
Have fun, Christian
On Tue, Oct 07, 2014 at 05:05:25PM +0200, quelltextlich e.U. - Christian Aistleitner wrote:
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@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@quelltextlich.at 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 Fax: +43 7946 / 20 5 81 Homepage: http://quelltextlich.at/
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics