powered by Jive Software

MySQL Getting Hit VERY heavily

I am seeing some strange issues with OpenFire. OpenFire is running SQL updates multiple times a second for the past several days. Resulting in Binary Logs 1-2 GBs with multiple log files.

This is using up all of the space on the system, and causing various other issues, as you can imagine.

I had to delete the BINARY LOGS, so I don’t know the exact SQL it is trying to run, but it is something to do with Buddy lists.