>Should we be the ones taking care of it? I'm not sure that the DB credentials I currently have can delete content. Neither the ones we have. In the absence of a regular cleanup process (which is on our team to do) i think we just have to request Sean Pringle to delete the data.
If anyone knows best please correct me. On Thu, Oct 2, 2014 at 9:28 AM, Gilles Dubuc <gil...@wikimedia.org> wrote: > 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 <mpinc...@wikimedia.org> > wrote: > >> Oh yeah, that'd be fine :) >> >> On Tue, Sep 30, 2014 at 10:38 AM, Ryan Kaldari <rkald...@wikimedia.org> >> 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 < >>> mpinc...@wikimedia.org> wrote: >>> >>>> On Mon, Sep 29, 2014 at 3:10 PM, Dario Taraborelli < >>>> dtarabore...@wikimedia.org> wrote: >>>> >>>>> On Sep 27, 2014, at 11:42 AM, Aaron Halfaker <ahalfa...@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? >>>>> >>>>> 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 <sprin...@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 >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Maryana Pinchuk >>>> Product Manager, Wikimedia Foundation >>>> wikimediafoundation.org >>>> >>> >>> >> >> >> -- >> Maryana Pinchuk >> Product Manager, Wikimedia Foundation >> wikimediafoundation.org >> >> _______________________________________________ >> 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 > >
_______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
