mysql-bin.0000xxx

October 2nd, 2009

upf… students error, setiap login keluar bacaan “ERROR: Connection dropped by IMAP server.”

langsung meluncur ke mesinnya…

cek log “tail -f /var/log/messages”

keluar

xxxxx

Oct 2 10:17:07 students kernel: pid 614 (mysqld), uid 88 inumber 283346 on /var: filesystem full

xxx

ketauan deh gara-garanya yaitu /var penuh…

langsung cek space “df -h”

students# df -h
Filesystem Size Used Avail Capacity Mounted on
xxx
/dev/ad0s1e 7.7G 7.1G -11M 100% /var

xxx

busyet -11 MB

oke masuk ke dalem direktori /var “cd /var”

cek penggunaan space oleh direktori-direktori dibaha /var “du -h -d1″

xxx

5.3G ./db

xxx

ternyata tuh /var/db yang paling makan space

masuk lagi ke /var/db “cd /var/db”

cek lagi direktori yang ngabisin space “du -h -d1″

xxx

5.1G ./mysql

xxx

yah ternyata si mysql yang ngabisin space

ngeliat isi direktori mysqlnya… “ll -h /var/db/myqsl”

wah ternyata didalemnya ada banyak file seperti ini..

-rw-rw—- 1 mysql mysql    31M May 6 02:55 mysql-bin.000001
-rw-rw—- 1 mysql mysql   441M May 26 16:56 mysql-bin.000002
-rw-rw—- 1 mysql mysql   303M Jun 10 09:25 mysql-bin.000003
-rw-rw—- 1 mysql mysql    17M Jun 11 09:14 mysql-bin.000004
-rw-rw—- 1 mysql mysql    39M Jun 13 14:08 mysql-bin.000005
-rw-rw—- 1 mysql mysql   1.0G Jul 30 07:15 mysql-bin.000006
-rw-rw—- 1 mysql mysql   158M Aug 6 09:56 mysql-bin.000007
-rw-rw—- 1 mysql mysql   2.6M Aug 6 12:32 mysql-bin.000008
-rw-rw—- 1 mysql mysql   859K Aug 6 13:25 mysql-bin.000009
-rw-rw—- 1 mysql mysql   1.6M Aug 6 15:15 mysql-bin.000010
-rw-rw—- 1 mysql mysql   997K Aug 6 15:27 mysql-bin.000011
-rw-rw—- 1 mysql mysql   2.8M Aug 6 18:19 mysql-bin.000012
-rw-rw—- 1 mysql mysql   116M Aug 12 06:55 mysql-bin.000013
-rw-rw—- 1 mysql mysql    77M Aug 16 06:25 mysql-bin.000014
-rw-rw—- 1 mysql mysql   138M Aug 23 15:45 mysql-bin.000015
-rw-rw—- 1 mysql mysql    35M Aug 25 14:18 mysql-bin.000016
-rw-rw—- 1 mysql mysql    76M Aug 29 02:05 mysql-bin.000017
-rw-rw—- 1 mysql mysql    12M Aug 29 15:51 mysql-bin.000018
-rw-rw—- 1 mysql mysql   171M Sep 6 00:40 mysql-bin.000019
-rw-rw—- 1 mysql mysql    87M Sep 9 21:40 mysql-bin.000020
-rw-rw—- 1 mysql mysql    21M Sep 11 04:20 mysql-bin.000021
-rw-rw—- 1 mysql mysql   311M Sep 28 10:32 mysql-bin.000022
-rw-rw—- 1 mysql mysql    60M Oct 2 10:31 mysql-bin.000023
-rw-rw—- 1 mysql mysql   437B Sep 28 10:35 mysql-bin.index