Page MenuHomePhabricator

MobileWebClickTracking table is huge and thus querying too slow
Closed, DeclinedPublic

Description

Currently 214GB of event logging data is logged around click tracking.

Maryana can confirm, but I think we don't need to log anything here beyond 2 months so it would be good to purge old data from this table or at very least back it up in a separate table as it makes this table very very slow to query.

In short term we should get this table down to a more manageable size.

Event Timeline

Jdlrobson raised the priority of this task from to Needs Triage.
Jdlrobson updated the task description. (Show Details)
Jdlrobson changed Security from none to None.
Jdlrobson subscribed.

I created some cards to make this table smaller and solve this on short term (see https://trello.com/c/thwAJVcN)
but on long term analytics team will need to find a way to keep the sizes manageable (it's currently 230gb and rising!)

we're no longer using this table. We split into multiple tables.