We can trim down our team (multimedia)'s tables considerably by getting rid of data older than 30 days. This could even be done by a daily cron. How would we go about doing that? Should we be the ones taking care of it? I'm not sure that the DB credentials I currently have can delete content.
On Tue, Sep 30, 2014 at 7:45 PM, Maryana Pinchuk <[email protected]> wrote: > Oh yeah, that'd be fine :) > > On Tue, Sep 30, 2014 at 10:38 AM, Ryan Kaldari <[email protected]> > wrote: > >> Maryana, would it be OK if we delete the MobileWebClickTracking records >> from before 2014? Would we still need those for any reason? >> >> On Tue, Sep 30, 2014 at 10:32 AM, Maryana Pinchuk <[email protected] >> > wrote: >> >>> On Mon, Sep 29, 2014 at 3:10 PM, Dario Taraborelli < >>> [email protected]> wrote: >>> >>>> On Sep 27, 2014, at 11:42 AM, Aaron Halfaker <[email protected]> >>>> 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? >>>> >>>> The mobile web team uses the MobileWebClickTracking to get a rough >>> heatmap of taps on prominent UI elements, and the apps team uses >>> MobileWikiAppToCInteraction >>> to measure engagement with the table of contents on the Wikipedia app. >>> They're both not primary metrics we're tracking but are useful to check in >>> on every once in awhile. Does that answer your question? >>> >>> >>>> >>>> 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 <[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 >>>> >>>> >>>> >>> >>> >>> -- >>> Maryana Pinchuk >>> Product Manager, Wikimedia Foundation >>> wikimediafoundation.org >>> >> >> > > > -- > Maryana Pinchuk > Product Manager, Wikimedia Foundation > wikimediafoundation.org > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
