I filed a ticket for Jaime to drop the MobileWebClickTracking_* table as analytics team doesn't have rights on DB:
https://phabricator.wikimedia.org/T120674 On Fri, Dec 4, 2015 at 2:09 PM, Jon Katz <[email protected]> wrote: > To confirm, this schema is still alive and growing--removing search from > it would help with size: > > Here is the most current table: > MobileWebUIClickTracking_10742159 > > On Fri, Dec 4, 2015 at 1:15 PM, Jon Robson <[email protected]> wrote: > >> That said I'm confused to see 3 events for 27th November 2015 from >> Russian and English Wikipedia so this table is growing - but I suspect >> this might be due to some mirror site? >> >> >> On Fri, Dec 4, 2015 at 1:13 PM, Jon Robson <[email protected]> wrote: >> > Jon This table isn't used to my knowledge any more. >> > MobileWebUIClickTracking tracks clicks to hamburger/search/language >> etc.. >> > MobileWebMainMenuClickTracking_11568715 clicks inside menu >> > MobileWebWatchlistClickTracking_10720361 inside watchlist feature >> > >> > MobileWebDiffClickTracking_10720373 within diff >> > The discovery team has MobileWebSearch_12054448 which tracks search >> behaviour. >> > >> > >> > On Fri, Dec 4, 2015 at 12:09 PM, Jon Katz <[email protected]> wrote: >> >> I think we should remove search events from it, but currently this is >> the >> >> only schema that tracks article-level actions. >> >> >> >> A while back we shrunk its predecessor by removing the hamburger menu >> >> actions, but the search actions account for the vast bulk of this >> table. >> >> Now that there is a separate search action table, I think we can remove >> >> search and shrink the table dramatically. >> >> -J >> >> >> >> On Fri, Dec 4, 2015 at 11:24 AM, Nuria Ruiz <[email protected]> >> wrote: >> >>> >> >>> Team: >> >>> >> >>> This schema >> https://meta.wikimedia.org/wiki/Schema:MobileWebClickTracking >> >>> has a lot of data in eventlogging. Tables are getting huge. >> >>> Too huge to be queried. >> >>> >> >>> I remember that we agreed to split this schema in several others, can >> we >> >>> do away with this schema now? >> >>> >> >>> Thanks, >> >>> >> >>> _______________________________________________ >> >>> Mobile-l mailing list >> >>> [email protected] >> >>> https://lists.wikimedia.org/mailman/listinfo/mobile-l >> >>> >> >> >> >> >> >> _______________________________________________ >> >> Mobile-l mailing list >> >> [email protected] >> >> https://lists.wikimedia.org/mailman/listinfo/mobile-l >> >> >> > >> > >> > >> > -- >> > Jon Robson >> > * http://jonrobson.me.uk >> > * https://www.facebook.com/jonrobson >> > * @rakugojon >> >> >> >> -- >> Jon Robson >> * http://jonrobson.me.uk >> * https://www.facebook.com/jonrobson >> * @rakugojon >> > >
_______________________________________________ Mobile-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mobile-l
