WordPress.org

Ready to get started?Download WordPress

Forums

Huge number of Sleeping Connections (5 posts)

  1. SEOJoe
    Member
    Posted 8 years ago #

    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.

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    What plugins are you running and does deactivating them all reduce the problem?
    Has the host supplied any useful information?

  3. SEOJoe
    Member
    Posted 8 years ago #

    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?

  4. oncidium
    Member
    Posted 8 years ago #

    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 | | |

  5. Quix0r
    Member
    Posted 7 years ago #

    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() ?

Topic Closed

This topic has been closed to new replies.

About this Topic