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
-- Jon Robson