On Sep 27, 2014, at 11:42 AM, Aaron Halfaker <ahalfaker(a)wikimedia.org> wrote:
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
D
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
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics