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 <jkatz@wikimedia.org> 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 <jdlrobson@gmail.com> 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 <jdlrobson@gmail.com> 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 <jkatz@wikimedia.org> 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 <nuria@wikimedia.org> 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
>>> Mobile-l@lists.wikimedia.org
>>> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>>>
>>
>>
>> _______________________________________________
>> Mobile-l mailing list
>> Mobile-l@lists.wikimedia.org
>> 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