WordPress.org

Forums

MySQL connections not closing (8 posts)

  1. Thord Daniel Hedengren
    Member
    Posted 9 years ago #

    My server provider is telling me that we have a lot of MySQL connections opening but not closing. This problem started when one of our larger sites went over to WordPress, so my conclusion is that there's something not right here. It also swamped the server's memory daily, which I think got back under control with the marvelous WP-cache2-plugin.

    Still, a lot of unclosed MySQL connections doesn't feel all that stable and I'm afraid that I'll have to reboot daily just to flush out the memory.

    Has anyone else had this problem? Any ideas?

  2. Thord Daniel Hedengren
    Member
    Posted 9 years ago #

    Anyone? Any ideas?

  3. davidchait
    Member
    Posted 9 years ago #

    sounds like the page is terminating early, and the connections aren't getting a chance to close. at least from a layman's pov. is there a timeout option for mysql? I mean, it probably won't help much, but an inactive open connection for more than some number of seconds is a likely candidate (30, 20, 15, 10?).

    we'd really need matt or other core dev to respond to this one...

  4. oncidium
    Member
    Posted 9 years ago #

    Me too. Did anyone get an answer for this problem?

  5. Marcel Brinkkemper
    Member
    Posted 9 years ago #

    I am experiencing this problem on my site too. And it's a very small site.
    Within 10 minutes after reboot MYSQL stops responding because of too many connections.
    It all started after I opened some files in Microsoft Web Designer. (ok shouldn't have done that)
    Now I have uploaded new WordPress 2.0.3 files.
    Let's see what will hapen.

  6. Marcel Brinkkemper
    Member
    Posted 9 years ago #

    Re-installing WordPress with 2.03 files didn't do the trick. Next step will be installing wp-cache.
    All this hassle for a blog with only 10 posts and 4 pages......

  7. Marcel Brinkkemper
    Member
    Posted 9 years ago #

    wp-cache helped a little. It took about a day in stead of an hour to hit my maximum connections level.I was using mysql version 4.1.17
    I have moved my site to a server with mysql version 4.1.20-standard. It looks like evrything ik OK now.

  8. Rodrigo M
    Member
    Posted 8 years ago #

    What about add a mysql_close at the footer?

    Would that help?

Topic Closed

This topic has been closed to new replies.

About this Topic