Page MenuHomePhabricator

delete useless wikimetrics.report or cohort records
Closed, DeclinedPublic

Description

Wikimetrics fills up a lot of space on the reports table with this problem:

A recurrent report is created on date X. It then spawns child reports every day from X to NOW. But it never deletes those child records. If those records are deleted, wikimetrics thinks the reports haven't run yet and runs them again. So every once in a while wikimetrics looks to be really slow because it's looking through 2 million records to find your reports and your report results.

We should set the created date of recurrent reports to NOW - 1 MONTH or something like that. And then we should delete old recurrent report child rows. Or find some other better solution, because currently we need to manually clean this up every once in a while.

Related Objects

Event Timeline

Milimetric raised the priority of this task from to Needs Triage.
Milimetric updated the task description. (Show Details)
Milimetric added a subscriber: Milimetric.
Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald TranscriptDec 7 2015, 8:23 PM
Milimetric set Security to None.
Milimetric renamed this task from delete useless wikimetrics.report records to delete useless wikimetrics.report or cohort records.Aug 29 2016, 3:46 PM
mforns closed this task as Declined.Mar 26 2019, 2:16 PM
mforns added a subscriber: mforns.

Declining because Wikimetrics is being discontinued. See: T211835.