WordPress.org

Support

Support » How-To and Troubleshooting » wp not closing mysql connections–61 open why?

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
    wpPHPMailer

    Thanks for your help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • I just recently had a similar situation. It wasn’t so much that the connections weren’t being closed; actually I had a long-running query that was blocking all the others (causing them to sit in a “locked” state). Once the Couple “bad” queries were killed, all the others were able to finish up.

    Dunno if the same applies to you, but see if anything in this thread help?
    http://wordpress.org/support/topic/136939?replies=20

    this actually does help a lot!

    but that’s what happens. The hosting service will hit the max connections, halt everything for about 2 minutes and then restart fresh. this happens every one or two days.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp not closing mysql connections–61 open why?’ is closed to new replies.