Occasionally, my site has major database problems.
I run 4 wordpresses, one of which has a fair amount of traffic. (the rest have trivial traffic).
Everything runs smoothly until certain occasions in which the db seems to be overwhelmed.
The hosting service reports:
"Well, our watchdog notified us it had to kill some of your MySql
> connections because you had 61 open connections to the 'rjnagle_xxx'
> database ... Do you have any idea why you might have that many open connections at the same time ?"
I'm not sure what he means or whether 61 open connections is abnormal. Can someone explains what is considered normal for a weblog with medium traffic.
Here's another interesting detail. We are running wp-shortstats which has bloated tables. 190 mb out of a 220 mb db. I can empty those tables and possibly remove the plugin.
But are there any other possible causes or things to look out for?
We have about 10-20 plugins running
All in One SEO Pack
Bunny's Technorati Tags
CJD Spam Nuke
Get Recent Comments
Google Ajax Search
Live Comment Preview
No Ping Wait
Simple Recent Comments
WordPress Database Backup
Thanks for your help.