Page MenuHomePhabricator

Drop database table "page_broken" from Wikimedia wikis
Closed, ResolvedPublic

Description

On at least enwiki, there is a "page_broken" database table that appears to be unused and unneeded.

Its number of rows:

MariaDB [enwiki_p]> select count(*) from page_broken;
+----------+

count(*)

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

722233

+----------+
1 row in set (0.16 sec)

This database table should be dropped from all Wikimedia wikis.


Version: wmf-deployment
Severity: enhancement

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:51 AM
bzimport set Reference to bz52930.

Have backed-up and dropped "page_broken" table from these wikis:

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

db

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

enwiki
cswiki
eowiki
plwiki
zhwiki
enwiki_p
cswiki_p
eowiki_p
plwiki_p
zhwiki_p

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

Change #1054796 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] filtered_tables.txt: Remove old table

https://gerrit.wikimedia.org/r/1054796

Change #1054796 merged by Marostegui:

[operations/puppet@production] filtered_tables.txt: Remove old table

https://gerrit.wikimedia.org/r/1054796