Monitoring causing HUGE mysql binary logs

Openfire Openfire Support
1

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

2

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?