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 <[email protected]> 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
