Our chat server is quite active and we routinely get really high load on our brand new database server. The hardware is quite good so there is something in the software that we would like to look into to tweak to reduce the load avgs.
Does any have any advice to make the database load more manageable?
Our current settings are the following:
Message Heart Beat: 7
Buddy List Heart Beat: 60
Online Timeout: 120
Idle Timeout: 3