powered by Jive Software

Monitoring causing HUGE mysql binary logs

I’m running Openfire 3.6.3 with the Monitoring plugin so that I can archive conversations. At the moment, Openfire is getting very minimal usage, yet I discovered that mySQL (used by Openfire) is creating 1 gigabyte binary logs every day! When I looked at the binary logs (using the mysqlbinlog tool), I discovered that the log was completely full of statements like this: UPDATE ofRRDs SET bytes = [lots of binary data].

I found this thread http://www.igniterealtime.org/community/message/172807 which says that this is a result of using RRD database to do the monitoring. So, to solve the problem, must I quit archiving conversations? Or turn off binary logging (which I can’t do because I’m replicating some other mySQL databases on the same server)?

Any suggestions would be most appreciated,

Thanks!

–Jeff

Have run into this issue with SQL Server as well. It looks like the Update commands to ofRRD are fired every minute - is there a way to change the interval to a longer amount of time and minimize the growth of those logs?