Page MenuHomePhabricator

Clean up backup metadata
Closed, DuplicatePublic

Description

Should we start cleaning up backup metada to leave data from a certain point in time?

Especially from this table:

root@db1159.eqiad.wmnet[dbbackups]> select count(*) from backup_files;
+-----------+
| count(*)  |
+-----------+
| 226609752 |
+-----------+
1 row in set (55.124 sec)
root@db1159.eqiad.wmnet[dbbackups]> select min(file_date) from backup_files;
+---------------------+
| min(file_date)      |
+---------------------+
| 2018-07-03 17:00:08 |
+---------------------+
1 row in set (1 min 12.060 sec)

Maybe we can just leave one year of data?