cacti disk space usage, mysql db huge

[spotman]

This is really weird.

I am using cacti to graph probably 100 devices or so, I believe I have upwards of around 2000 data sources.

I used cactid and its running on FreeBSD 5.4, with the latest mysql package from the ports collection.

When I export my sql database (I use phpmyadmin, or mysqldump), it is about 10 megabytes in size.

However, on the disk, the /usr/local/data/mysql directory is about 28 GIGS!

Is this typical? Does this just have something to do with how mysql stores data?

I am quickly running out of disk space, I have noticed that the rrd files are weird as well. For some of my switches, the rrd file is 7 megabytes, while for most of them they are about 96k - 184k. I actually deleted a few of the 7mb ones, and they regenerated @ 96k?

I am running cacti 86g, I am also using the threshold mod.

The biggest issue is that I am trying to figure out why my disk space keeps getting eaten up if rrd files are not eating up that much size. All this server does is do cacti. It just seems that the sql directory is growing and growing, but the db size seems the same?

Thank you for any help!

It is greatly appreciated~
-scott

[rony]

You probably have binary logging enabled in mysql.

Disable it.

[spotman]

Ok I think I have disabled it. I uncommented "log-bin" from the /etc/my.cnf file.

Is it ok to delete the files that named meter-bin.00001, meter-bin.00002, etc, that are located in /usr/local/data/mysql (meter is this server's hostname)

These files ($hostname-bin.00000x) are the ones that are huge. There is many of them, probably one for each day it appears, maybe give or take...

Thank you so much for your help!
-scott

[rkramer]

it is relatively safe to delete them, although the correct (and better) method is to issue a 'RESET MASTER' command to mysql.

http://dev.mysql.com/doc/refman/5.0/en/reset.html