Page MenuHomePhabricator

Drop flaggedtemplates in production
Closed, ResolvedPublic

Description

Now that T359529: Future of flaggedtemplates feature is stable in production and no major issues for a week now. I think we can move forward with dropping it.

It hasn't been written into since March 28:

root@db1194:/srv/sqldata# ls -l */flaggedte*
-rw-rw---- 1 mysql mysql         964 Apr 11  2022 arwiki/flaggedtemplates.frm
-rw-rw---- 1 mysql mysql 51803848704 Mar 28 22:16 arwiki/flaggedtemplates.ibd
-rw-rw---- 1 mysql mysql         964 Apr 11  2022 fawiki/flaggedtemplates.frm
-rw-rw---- 1 mysql mysql       98304 Apr 11  2022 fawiki/flaggedtemplates.ibd
-rw-rw---- 1 mysql mysql         964 Nov 18  2022 huwiki/flaggedtemplates.frm
-rw-rw---- 1 mysql mysql  6559891456 Mar 28 21:59 huwiki/flaggedtemplates.ibd
-rw-rw---- 1 mysql mysql         964 Apr 11  2022 ukwiki/flaggedtemplates.frm
-rw-rw---- 1 mysql mysql 23165140992 Mar 28 22:09 ukwiki/flaggedtemplates.ibd

Around 80GB in s7, 50GB in s2, and 40GB in s6, 40GB in s3 will be removed.

Event Timeline

ABran-WMF triaged this task as Medium priority.
ABran-WMF moved this task from Triage to Ready on the DBA board.
Ladsgroup moved this task from Ready to In progress on the DBA board.
Ladsgroup added a subscriber: ABran-WMF.

After talking to Arnaud, I'm stealing this.

Dropped in ruwiki (s6) and dewiki (s5)

DROP TABLE IF EXISTS flaggedtemplates;

Will wait for a bit and then drop it everywhere.

Ladsgroup moved this task from In progress to Done on the DBA board.