What plugins are you running and does deactivating them all reduce the problem?
Has the host supplied any useful information?
Thread Starter
seojoe
(@seojoe)
the only plugin I’m running is WP-PageNavi http://www.lesterchan.net/portfolio/programming.php
I’ll deactivate it and see what happens. The host really isn’t being that much help sadly. They’ve told me the time that it seems to spike and that’s about the same time that I do several posts. Could that be creating the massive #’s of sleeping connections?
I am having a similar problem. My host said he is having to restart about 3x /day because of the open connections. Here is some more info…all of this is beyond the scope of what I know to do about WP stuff:
235 | cherylke_cheryl | localhost | cherylke_ | Sleep | 8147 | | |
| 2439 | cherylke_cheryl | localhost | cherylke_ | Sleep | 4493 | | |
| 2459 | cherylke_cheryl | localhost | cherylke_ | Sleep | 4463 | | |
| 3324 | cherylke_cheryl | localhost | cherylke_ | Sleep | 3202 | | |
| 3754 | cherylke_cheryl | localhost | cherylke_ | Sleep | 2722 | | |
I don’t have such problems here. Well, I don’t have so much high traffic on my weblog. In includes/wp-db.php WP is using mysql_connect() by default. Maybe you want to change this to mysql_pconnect() ?