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?

neither I nor Oliver are using this data but it’s used for some Limn dashboards by the Mobile team. Copying Maryana and Kaldari so they can chime in

On Sat, Sep 27, 2014 at 2:02 PM, Sean Pringle <springle@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@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics