wp not closing mysql connections–61 open why?
-
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
AdSense Manager
All in One SEO Pack
Bunny’s Technorati Tags
Category Order
CJD Spam Nuke
Get Recent Comments
Google Ajax Search
Live Comment Preview
No Ping Wait
Popularity Contest
Search Everything
SezWho
Simple Recent Comments
Sociable
Translate
WordPress Database Backup
WP-CaTT
WP-DBManager
WP-PageNavi
WP-Polls
WP-ShortStat
WP-Stats
WP-Sticky
WP-UserOnline
wpPHPMailerThanks for your help.
- The topic ‘wp not closing mysql connections–61 open why?’ is closed to new replies.