I'm not altogether sure it's a good idea to turn it back on again. I saw that the forum had gone off-line around 11PM CST on the 16th, and backtracking the data looks like the stripped-down CHAT that I'd installed at RavishU may well be the culprit. There were around 8 to 10 people in chat at the time that the server load went ballistic. I only caught the tail end of it in the graphic below:
I've looked at the raw access logs 6 ways to Sunday, and the CHAT is the only thing I can see during the time that the server load was high. Everything else (a couple of hundred GUESTS on each forum plus a few members) doesn't come close to explaining it, due to the other measures currently in place (both Google and MSN bots banned). I'll probably relax the ban on Google this next week if I can get a handle on what's causing the load spikes, but right now it's looking like CHAT over at RavishU.
If the CHAT is causing the load spikes, then simply installing a stand-alone version that doesn't interface with the main forum database might correct it. The frequent pops on our utterly HUGE forum databases may well be causing the bulk of the problems here. Both Kristen's and RavishU forum databases are in the realm of 200-300meg, which is probably straining the SQL server.
The only way I'll know for sure if it's CHAT is to be on-line and watching the server load when a spike happens. I can turn off the CHAT and see if the load plummets. If it does, then I need to think seriously about installing it stand-alone or losing it entirely.
« Last Edit: May 18, 2014, 10:52:54 AM by RopeFiend »
Remember the Golden Rule: you do me, and I\'ll do you (paraphrased)