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,