WordPress.org

Ready to get started?Download WordPress

Forums

WP Zombaio
[resolved] Not closing connections? (3 posts)

  1. Esinem
    Member
    Posted 5 months ago #

    On one of the sites I run, a colleague installed WP Zombaio. Whether it is merely coincidental or not we are trying to discover but we began to experience random d/b connection errors immediately after.

    On trying to repair/rebuild the d/b, we got:

    "User Uxxxxx already has more than 'max_user_connections' active connections"

    Tech support replied:

    "The error that occurred happens when an account on the server is opening to many connections to mysql on the server This happens sometimes with poorly written code that leaves connections open and keeps opening more connections. When one account does this it effects the entire mysql server resulting in the error you received and is only fixed when we find the issue and stop those lingering connections.

    When you tell your website to do anything with the database, remember to then CLOSE the connection. You are on SHARED hosting, so if your database is holding open half the doors - other users will suffer.

    mysql_close();

    Very easy to add at the end of pages with SQL commands!

    Max connections allowed at a time per database: 20 connections"

    Is this related to WP Zombaio? As you will appreciate, previous experience with WordPress/Zombaio integration leads me to look here first.

    Pending a reply, we have deactivated WP Zombaio to see if this does indeed cure the problem.

    https://wordpress.org/plugins/wp-zombaio/

  2. Barry Carlyon
    Member
    Plugin Author

    Posted 5 months ago #

    I'm 99.9% sure it is unrelated to WP-Zombaio.

    As WP-Zombaio is a plugin for WordPress, all database operations are left to WordPress to open and close.

    Further more, to your proposed solution from your host, WP-Zombaio is in the middle of the page, so if it closes the database connection, other plugins and the rest of the page will have issues using the database.

    Sounds like the hosting is badly configured.

    See also this answer: http://stackoverflow.com/questions/1202322/mysql-error-too-many-connections

  3. Esinem
    Member
    Posted 5 months ago #

    OK, cool. Thanks, will check out the link

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.