I'm not surprised that PageContentSaveComplete is big. That's a very
useful table and it sees a lot of rows for good reason (every revision
saved on every wiki).
As for the Multimedia/Mediaviewer tables, we should probably ping someone
on that team to discuss them.
Dario, can you speak for the MobileWebClickTracking and
MobileWikiAppToCInteraction schemas?
-Aaron
On Sat, Sep 27, 2014 at 2:02 PM, Sean Pringle <springle(a)wikimedia.org>
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