Can we have a look for any tables with "pre_" in the name, as those would be backup tables that can go too
Deletion progress:
- s2
- eqiad
- codfw
- s3
- eqiad
- codfw
- s4
- eqiad
- codfw
- s5
- eqiad
- codfw
- s6
- eqiad
- codfw
- s7
- eqiad
- codfw
Can we have a look for any tables with "pre_" in the name, as those would be backup tables that can go too
Deletion progress:
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 | T118859 Drop backup tables for old schema changes (aka "x_pre_y" tables) |
I have backuped the existing tables at dbstore1001:
root@dbstore1001:/srv/tmp/T118859# pwd /srv/tmp/T118859 root@dbstore1001:/srv/tmp/T118859# ls -lh total 997M -rw-r--r-- 1 root root 463M Jul 24 07:45 s2.tar.gz -rw-r--r-- 1 root root 101M Jul 24 07:50 s3.tar.gz -rw-r--r-- 1 root root 177M Jul 24 07:54 s4.tar.gz -rw-r--r-- 1 root root 82M Jul 24 07:56 s5.tar.gz -rw-r--r-- 1 root root 78M Jul 24 08:00 s6.tar.gz -rw-r--r-- 1 root root 98M Jul 24 08:01 s7.tar.gz
Mentioned in SAL (#wikimedia-operations) [2018-04-23T06:26:57Z] <marostegui> Remove logging_pre_1_10 from codfw - T118859
Mentioned in SAL (#wikimedia-operations) [2018-04-23T07:47:25Z] <marostegui> Drop table logging_pre_1_10 in s6 - T118859
Mentioned in SAL (#wikimedia-operations) [2018-04-23T07:50:08Z] <marostegui> Drop table logging_pre_1_10 in s2 - T118859
Mentioned in SAL (#wikimedia-operations) [2018-04-23T08:13:02Z] <marostegui> Drop table logging_pre_1_10 in s7 - T118859
Mentioned in SAL (#wikimedia-operations) [2018-04-23T08:30:07Z] <marostegui> Drop table logging_pre_1_10 in s4 - T118859
Mentioned in SAL (#wikimedia-operations) [2018-04-23T08:47:01Z] <marostegui> Dropped table logging_pre_1_10 in s3 - T118859
Mentioned in SAL (#wikimedia-operations) [2018-04-23T08:47:16Z] <marostegui> Drop table logging_pre_1_10 in s5 - T118859