Maniphest T193390

Drop flaggedrevs tables at metawiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	MarcoAurelio
	Apr 30 2018, 11:43 AM

Description

MariaDB [metawiki_p]> show tables like 'flag%';

+------------------------------+

| Tables_in_metawiki_p (flag%) |

+------------------------------+

| flaggedimages                |

| flaggedpage_config           |

| flaggedpage_pending          |

| flaggedpages                 |

| flaggedrevs                  |

| flaggedrevs_promote          |

| flaggedrevs_statistics       |

| flaggedrevs_tracking         |

| flaggedtemplates             |

+------------------------------+

9 rows in set (0.00 sec)

FlaggedRevs was never used on Meta-Wiki and I suspect it was briefly added there as some sort of experiment. I don't think keeping those tables is needed.

Related Objects
Search...

Status	Subtype	Assigned	Task
Open	Feature	None	T18660 Database table cleanup (tracking)
Resolved		LSobanski	T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking)
Resolved		• Marostegui	T174801 Drop flaggedrevs tables on wikis where it is not enabled
Resolved		• Marostegui	T193390 Drop flaggedrevs tables at metawiki

Event Timeline

MarcoAurelio created this task.Apr 30 2018, 11:43 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 30 2018, 11:43 AM

MarcoAurelio updated the task description. (Show Details)Apr 30 2018, 11:44 AM

MarcoAurelio added a parent task: T174801: Drop flaggedrevs tables on wikis where it is not enabled.Apr 30 2018, 11:46 AM

• Marostegui moved this task from Triage to Backlog on the DBA board.Apr 30 2018, 1:15 PM

I would assume the data is necessary to be backed up, no?
There is only data on these tables:

flaggedrevs
+----------+
| count(*) |
+----------+
|      185 |
+----------+
flaggedrevs_promote
+----------+
| count(*) |
+----------+
|      846 |
+----------+
flaggedrevs_statistics
+----------+
| count(*) |
+----------+
|    99380 |
+----------+

They have not been written since 2014/2015

I have backuped them just in case and left them at: dbstore1001:/srv/backups/tmp/T193390.tar.gz

Mentioned in SAL (#wikimedia-operations) [2018-05-03T05:59:32Z] <marostegui> Drop mostly empty flagged* tables from metawiki (s7) - T193390

Dropped them

• Vvjjkkii renamed this task from Drop flaggedrevs tables at metawiki to dzdaaaaaaa.Jul 1 2018, 1:13 AM

• Vvjjkkii reopened this task as Open.

• Vvjjkkii removed • Marostegui as the assignee of this task.

• Vvjjkkii raised the priority of this task from Medium to High.

• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).

• Vvjjkkii updated the task description. (Show Details)

• Vvjjkkii removed subscribers: MarcoAurelio, Aklapper.

• Marostegui renamed this task from dzdaaaaaaa to Drop flaggedrevs tables at metawiki.Jul 1 2018, 6:23 PM

• Marostegui closed this task as Resolved.

• Marostegui claimed this task.

• Marostegui lowered the priority of this task from High to Medium.

• Marostegui removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.

• Marostegui updated the task description. (Show Details)

• Marostegui added subscribers: MarcoAurelio, Aklapper.

Drop flaggedrevs tables at metawikiClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Drop flaggedrevs tables at metawiki
Closed, ResolvedPublic
Actions

Related Objects
Search...