Huge number of Sleeping Connections

  • WordPress seems to not be closing db connections it makes. there was about 100 sleeping connections ranging from 100seconds to 1000seconds and it caused my site to go down. any idea why WP is leaving the connections open?

    I’m running WP 2.0.2 and the site is between 10-15k/day uniques.

Viewing 4 replies - 1 through 4 (of 4 total)

  • 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 https://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() ?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Huge number of Sleeping Connections’ is closed to new replies.

Tags