Page MenuHomePhabricator

Need to empty "linter" database table on large wikis
Closed, ResolvedPublic

Description

Hi DBA

We need to reset the linter table on all large wikis (https://noc.wikimedia.org/conf/highlight.php?file=large.dblist). Should I just use runBatchedQuery.php to delete all the rows or is there a preferred DBA way to do this?

Event Timeline

Legoktm created this task.Jun 13 2017, 3:35 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 13 2017, 3:35 AM

Hi

Yes, if you could use the script, that would be preferred so we do not have to touch the tables manually and you have all the throttling mechanism already implemented :-)
Also please schedule that script on the Deployments page: https://wikitech.wikimedia.org/wiki/Deployments so we and people are aware of it when it runs.

Lastly, if possible, if you can give us some heads up before running it that would be appreciated, so we can keep it in mind if we are doing some maintenance or see strange patterns on graphs

Thanks!!

Marostegui triaged this task as Medium priority.Jun 13 2017, 5:16 AM
Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.

@Marostegui Is it alright if I start it now?

Mentioned in SAL (#wikimedia-operations) [2017-06-13T18:54:47Z] <legoktm> starting to delete all rows from linter tables on large wikis - T167758

Legoktm closed this task as Resolved.Jun 13 2017, 10:02 PM
Legoktm claimed this task.

All done!