[Savannah-hackers-public] internal is getting low on disk space

[Bob Proulx]

Savannah Hackers,

The internal VM is getting low on disk space.

  internal:~# df -lh
  Filesystem            Size  Used Avail Use% Mounted on
  /dev/xvda2             20G   19G  1.5G  93% /

It isn't in the mysql database.

  internal:~# du -sh /var/lib/mysql/
  495M    /var/lib/mysql/

I ran "du -xml /", looked at the result with 'xdu' and found the
space.

  internal:~# du -sh /dumps/savane/
  16G     /dumps/savane/

Daily snapshots going back to 2013-09-28.  Plus some older dumps from
2010.  I will plan on deleting the 2010 numbered snapshots initially.
I think for the others we need to prune off some days.  Maybe a scheme
like for older ones only keeping one a week and then only one a month.
That would allow us to have fairly long backups but without quite so
much disk space used.

Bob

ls -l /dumps/savane
total 16281040
-rw-r--r-- 1 root root 261849208 Nov 15  2007 old_savannah.sql.gz.1
-rw-r--r-- 1 root root 244632133 Aug  8  2007 old_savannah.sql.gz.100
-rw-r--r-- 1 root root 149365930 Jan  5 06:27 savane.sql.gz
-rw-r--r-- 1 root root 138842285 Sep 27 06:27 savane.sql.gz-20130928
-rw-r--r-- 1 root root 138929715 Sep 28 06:27 savane.sql.gz-20130929
-rw-r--r-- 1 root root 138992380 Sep 29 06:27 savane.sql.gz-20130930
-rw-r--r-- 1 root root 139100694 Sep 30 06:27 savane.sql.gz-20131001
-rw-r--r-- 1 root root 139184828 Oct  1 06:27 savane.sql.gz-20131002
-rw-r--r-- 1 root root 139259044 Oct  2 06:27 savane.sql.gz-20131003
-rw-r--r-- 1 root root 139354703 Oct  3 06:27 savane.sql.gz-20131004
-rw-r--r-- 1 root root 139466911 Oct  4 06:28 savane.sql.gz-20131005
-rw-r--r-- 1 root root 139471893 Oct  5 06:26 savane.sql.gz-20131006
-rw-r--r-- 1 root root 139449780 Oct  6 06:26 savane.sql.gz-20131007
-rw-r--r-- 1 root root 139534423 Oct  7 06:27 savane.sql.gz-20131008
-rw-r--r-- 1 root root 139763233 Oct  8 06:27 savane.sql.gz-20131009
-rw-r--r-- 1 root root 139730371 Oct  9 06:26 savane.sql.gz-20131010
-rw-r--r-- 1 root root 139855512 Oct 10 06:28 savane.sql.gz-20131011
-rw-r--r-- 1 root root 139934539 Oct 11 06:27 savane.sql.gz-20131012
-rw-r--r-- 1 root root 140023496 Oct 12 06:27 savane.sql.gz-20131013
-rw-r--r-- 1 root root 140023876 Oct 13 06:27 savane.sql.gz-20131014
-rw-r--r-- 1 root root 140057078 Oct 14 06:26 savane.sql.gz-20131015
-rw-r--r-- 1 root root 140087089 Oct 15 06:27 savane.sql.gz-20131016
-rw-r--r-- 1 root root 140220826 Oct 16 06:27 savane.sql.gz-20131017
-rw-r--r-- 1 root root 140343206 Oct 17 06:27 savane.sql.gz-20131018
-rw-r--r-- 1 root root 140619613 Oct 18 06:26 savane.sql.gz-20131019
-rw-r--r-- 1 root root 140604448 Oct 19 06:27 savane.sql.gz-20131020
-rw-r--r-- 1 root root 140573356 Oct 20 06:27 savane.sql.gz-20131021
-rw-r--r-- 1 root root 140744415 Oct 21 06:26 savane.sql.gz-20131022
-rw-r--r-- 1 root root 140793767 Oct 22 06:27 savane.sql.gz-20131023
-rw-r--r-- 1 root root 140866877 Oct 23 06:27 savane.sql.gz-20131024
-rw-r--r-- 1 root root 141033277 Oct 24 06:26 savane.sql.gz-20131025
-rw-r--r-- 1 root root 141126452 Oct 25 06:26 savane.sql.gz-20131026
-rw-r--r-- 1 root root 141151734 Oct 26 06:26 savane.sql.gz-20131027
-rw-r--r-- 1 root root 141219800 Oct 27 06:26 savane.sql.gz-20131028
-rw-r--r-- 1 root root 141407262 Oct 28 06:27 savane.sql.gz-20131029
-rw-r--r-- 1 root root 141451386 Oct 29 06:27 savane.sql.gz-20131030
-rw-r--r-- 1 root root 141564249 Oct 30 06:26 savane.sql.gz-20131031
-rw-r--r-- 1 root root 141643413 Oct 31 06:27 savane.sql.gz-20131101
-rw-r--r-- 1 root root 141736464 Nov  1 06:26 savane.sql.gz-20131102
-rw-r--r-- 1 root root 141894986 Nov  2 06:26 savane.sql.gz-20131103
-rw-r--r-- 1 root root 142035019 Nov  3 06:27 savane.sql.gz-20131104
-rw-r--r-- 1 root root 142089446 Nov  4 06:26 savane.sql.gz-20131105
-rw-r--r-- 1 root root 142138209 Nov  5 06:28 savane.sql.gz-20131106
-rw-r--r-- 1 root root 142263364 Nov  6 06:27 savane.sql.gz-20131107
-rw-r--r-- 1 root root 142356104 Nov  7 06:26 savane.sql.gz-20131108
-rw-r--r-- 1 root root 142471873 Nov  8 06:27 savane.sql.gz-20131109
-rw-r--r-- 1 root root 142672346 Nov  9 06:26 savane.sql.gz-20131110
-rw-r--r-- 1 root root 142741292 Nov 10 06:28 savane.sql.gz-20131111
-rw-r--r-- 1 root root 142847214 Nov 11 06:26 savane.sql.gz-20131112
-rw-r--r-- 1 root root 143052364 Nov 12 06:27 savane.sql.gz-20131113
-rw-r--r-- 1 root root 143145323 Nov 13 06:27 savane.sql.gz-20131114
-rw-r--r-- 1 root root 143213946 Nov 14 06:26 savane.sql.gz-20131115
-rw-r--r-- 1 root root 143356453 Nov 15 06:26 savane.sql.gz-20131116
-rw-r--r-- 1 root root 143419356 Nov 16 06:27 savane.sql.gz-20131117
-rw-r--r-- 1 root root 143439972 Nov 17 06:26 savane.sql.gz-20131118
-rw-r--r-- 1 root root 143545457 Nov 18 06:26 savane.sql.gz-20131119
-rw-r--r-- 1 root root 143702949 Nov 19 06:26 savane.sql.gz-20131120
-rw-r--r-- 1 root root 143835630 Nov 20 06:26 savane.sql.gz-20131121
-rw-r--r-- 1 root root 143916384 Nov 21 06:26 savane.sql.gz-20131122
-rw-r--r-- 1 root root 144037499 Nov 22 06:26 savane.sql.gz-20131123
-rw-r--r-- 1 root root 144031939 Nov 23 06:26 savane.sql.gz-20131124
-rw-r--r-- 1 root root 144105619 Nov 24 06:27 savane.sql.gz-20131125
-rw-r--r-- 1 root root 144210011 Nov 25 06:26 savane.sql.gz-20131126
-rw-r--r-- 1 root root 144386508 Nov 26 06:27 savane.sql.gz-20131127
-rw-r--r-- 1 root root 144437471 Nov 27 06:26 savane.sql.gz-20131128
-rw-r--r-- 1 root root 144527033 Nov 28 06:26 savane.sql.gz-20131129
-rw-r--r-- 1 root root 144579993 Nov 29 06:27 savane.sql.gz-20131130
-rw-r--r-- 1 root root 144655036 Nov 30 06:27 savane.sql.gz-20131201
-rw-r--r-- 1 root root 144699899 Dec  1 06:27 savane.sql.gz-20131202
-rw-r--r-- 1 root root 144729855 Dec  2 06:27 savane.sql.gz-20131203
-rw-r--r-- 1 root root 144824549 Dec  3 06:27 savane.sql.gz-20131204
-rw-r--r-- 1 root root 144885436 Dec  4 06:27 savane.sql.gz-20131205
-rw-r--r-- 1 root root 144999379 Dec  5 06:26 savane.sql.gz-20131206
-rw-r--r-- 1 root root 145216871 Dec  6 06:27 savane.sql.gz-20131207
-rw-r--r-- 1 root root 145393192 Dec  7 06:26 savane.sql.gz-20131208
-rw-r--r-- 1 root root 145440961 Dec  8 06:27 savane.sql.gz-20131209
-rw-r--r-- 1 root root 145535956 Dec  9 06:28 savane.sql.gz-20131210
-rw-r--r-- 1 root root 145745013 Dec 10 06:27 savane.sql.gz-20131211
-rw-r--r-- 1 root root 146007389 Dec 11 06:26 savane.sql.gz-20131212
-rw-r--r-- 1 root root 146187620 Dec 12 06:26 savane.sql.gz-20131213
-rw-r--r-- 1 root root 146333603 Dec 13 06:26 savane.sql.gz-20131214
-rw-r--r-- 1 root root 146456427 Dec 14 06:26 savane.sql.gz-20131215
-rw-r--r-- 1 root root 146431000 Dec 15 06:28 savane.sql.gz-20131216
-rw-r--r-- 1 root root 146569775 Dec 16 06:27 savane.sql.gz-20131217
-rw-r--r-- 1 root root 146825731 Dec 17 06:27 savane.sql.gz-20131218
-rw-r--r-- 1 root root 147035143 Dec 18 06:26 savane.sql.gz-20131219
-rw-r--r-- 1 root root 147257091 Dec 19 06:27 savane.sql.gz-20131220
-rw-r--r-- 1 root root 147445829 Dec 20 06:26 savane.sql.gz-20131221
-rw-r--r-- 1 root root 147606717 Dec 21 06:26 savane.sql.gz-20131222
-rw-r--r-- 1 root root 147776513 Dec 22 06:27 savane.sql.gz-20131223
-rw-r--r-- 1 root root 147927024 Dec 23 06:26 savane.sql.gz-20131224
-rw-r--r-- 1 root root 148134792 Dec 24 06:26 savane.sql.gz-20131225
-rw-r--r-- 1 root root 148165545 Dec 25 06:26 savane.sql.gz-20131226
-rw-r--r-- 1 root root 148230451 Dec 26 06:26 savane.sql.gz-20131227
-rw-r--r-- 1 root root 148352705 Dec 27 06:26 savane.sql.gz-20131228
-rw-r--r-- 1 root root 148526391 Dec 28 06:26 savane.sql.gz-20131229
-rw-r--r-- 1 root root 148646062 Dec 29 06:26 savane.sql.gz-20131230
-rw-r--r-- 1 root root 148709611 Dec 30 06:26 savane.sql.gz-20131231
-rw-r--r-- 1 root root 148854599 Dec 31 06:26 savane.sql.gz-20140101
-rw-r--r-- 1 root root 148921130 Jan  1 06:26 savane.sql.gz-20140102
-rw-r--r-- 1 root root 149027698 Jan  2 06:26 savane.sql.gz-20140103
-rw-r--r-- 1 root root 149120450 Jan  3 06:26 savane.sql.gz-20140104
-rw-r--r-- 1 root root 149268785 Jan  4 06:26 savane.sql.gz-20140105
-rw-r--r-- 1 root root 158980084 Dec 17  2010 savane.sql.gz.1
-rw-r--r-- 1 root root  65683079 Jan 21  2009 savane.sql.gz.100
-rw-r--r-- 1 root root 158678543 Dec 16  2010 savane.sql.gz.2
-rw-r--r-- 1 root root 158737589 Nov 20  2010 savane.sql.gz.20
-rw-r--r-- 1 root root 158546520 Dec 15  2010 savane.sql.gz.3
-rw-r--r-- 1 root root 158383000 Dec 14  2010 savane.sql.gz.4
-rw-r--r-- 1 root root 158140359 Dec 13  2010 savane.sql.gz.5
-rw-r--r-- 1 root root 157890216 Dec 12  2010 savane.sql.gz.6
-rw-r--r-- 1 root root 157772372 Dec 11  2010 savane.sql.gz.7
-rw-r--r-- 1 root root 157647151 Dec 10  2010 savane.sql.gz.8
-rw-r--r-- 1 root root 157713738 Dec  9  2010 savane.sql.gz.9