MySQl database keeps growing

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
barta
Posts: 1
Joined: Mon Aug 10, 2009 6:12 am
Location: Netherlands

MySQl database keeps growing

Post by barta »

I use Cacti in a small setup, monitoring 17 devices, but strangely de database keeps growing rather fast.

I have thrown away already 13 gigs of database files (running 5 months), without any functional impairment.

What can be the cause of this behaviour ?

Is it Cacti-related or MySQL ?

What can I do about it, except for the manual clean-up ?

Any help is welcome ....

Information:

OS: Windows Server 2003

cacti 0.8.7c
rdd tool 1.2.15

WAMP-package:
apache 2.2.11
mySQl 5.1.30
PHP 5.2.8

net-snmp 5.4.2.1

no plugins
User avatar
schurzi
Posts: 42
Joined: Sat Oct 11, 2008 8:45 am
Location: Germany
Contact:

Post by schurzi »

I think you problem are the MySQL bin logs.

Please see this Thread for a solution:
http://forums.cacti.net/viewtopic.php?t ... highlight=

Also note, that the my.cnf in you case might be a my.ini and it should be located somewhere in your mysql installation.
"Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it." - Brian W. Kernighan
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests