Hello,
root@dbstore1002:/srv# df -hT /srv/ Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/tank-data xfs 6.4T 5.5T 905G 87% /srv
There is still room, but I thought I would report this so we don't get caught on a 95% status :-)
What I have seen so far is that we have lots of tables on InnoDB and not TokuDB which could give us some more space.
These are the two ones:
-rw-rw---- 1 mysql mysql 201G Sep 26 13:55 ./sqldata/metawiki/pagelinks.ibd -rw-rw---- 1 mysql mysql 155G Sep 26 13:55 ./sqldata/wikidatawiki/revision.ibd -rw-rw---- 1 mysql mysql 116G Sep 26 13:55 ./sqldata/enwiki/slots.ibd -rw-rw---- 1 mysql mysql 89G Sep 26 13:55 ./sqldata/wikidatawiki/change_tag.ibd -rw-rw---- 1 mysql mysql 78G Sep 26 13:48 ./sqldata/enwiki/content.ibd -rw-rw---- 1 mysql mysql 72G Sep 26 13:55 ./sqldata/wikidatawiki/slots.ibd -rw-rw---- 1 mysql mysql 70G Sep 26 13:55 ./sqldata/wikidatawiki/content.ibd -rw-rw---- 1 mysql mysql 65G Sep 26 13:55 ./sqldata/dewiki/flaggedimages.ibd -rw-rw---- 1 mysql mysql 60G Sep 26 13:55 ./sqldata/wikidatawiki/text.ibd -rw-rw---- 1 mysql mysql 53G Sep 26 13:55 ./sqldata/wikishared/cx_corpora.ibd -rw-rw---- 1 mysql mysql 51G Sep 26 13:55 ./sqldata/srwiki/pagelinks.ibd -rw-rw---- 1 mysql mysql 37G Sep 26 13:55 ./sqldata/wikidatawiki/echo_event.ibd -rw-rw---- 1 mysql mysql 39G Sep 26 13:55 ./sqldata/viwiki/pagelinks.ibd
Specially interesting is:
-rw-rw---- 1 mysql mysql 77G Oct 11 2017 ./sqldata/commonswiki_test_T177772/recentchanges.ibd root@dbstore1002:/srv/sqldata/commonswiki_test_T177772# ls -lh total 77G -rw-rw---- 1 mysql mysql 54 Oct 9 2017 db.opt -rw-rw---- 1 mysql mysql 8.1K Oct 9 2017 recentchanges.frm -rw-rw---- 1 mysql mysql 77G Oct 11 2017 recentchanges.ibd
I think that directory can be just dropped all at once.
I propose we start converting some of those 50GB tables to TokuDB and see how much space we gain and then continue with other ones until we are back in a good state until the new servers arrive.