@Volans found this the other day when switching DNS on the mysql master, I have not been able to find anyone who knows what it is and there are no references to it in frack puppet so I think it can go.
Other people who I think might want to weigh in: @Pcoombe @CCogdill_WMF @Seddon ?
How many rows are in the tables? There should be a timestamp column, often ts, to query. It's probably worth keeping an archival dump if it might be real data.
Where is this database? I cannot find it on the misc masters.
root@cumin1001:~# for i in db1063 db1065 db1072 db1073; do mysql.py -h$i -e "show databases like '%fr%'";done root@cumin1001:~#
So looks like it is only on codfw hosts, which indicates it is not really in use:
root@cumin1001:/home/marostegui# for i in db1065 db1117:3322 db2044 db2078:3322; do echo $i; mysql.py -h$i -e "show databases like '%fr%'";done db1065 db1117:3322 db2044 +-----------------+ | Database (%fr%) | +-----------------+ | frimpressions | +-----------------+ db2078:3322 +-----------------+ | Database (%fr%) | +-----------------+ | frimpressions | +-----------------+
our backup systems has this bug where empty dbs are not recovered, maybe it is an empty and was deleted by accident (with no data loss?).
it is empty actually
root@db2044:/srv/sqldata/frimpressions# ls -lh total 4.0K -rw-rw---- 1 mysql mysql 54 Jun 4 2014 db.opt
awight - do you need its contents? Maybe it was archived in the past, we would have to do some research about that.
Mentioned in SAL (#wikimedia-operations) [2019-01-17T14:19:29Z] <marostegui> Drop empty frimpressions database from m2 - T213973