WordPress.org

Ready to get started?Download WordPress

Forums

AdRotate
[resolved] Adrotate doesn't close mysql connections? (7 posts)

  1. simpson-fan
    Member
    Posted 10 months ago #

    Since a few days (maybe since the last update) my WordPress blog looses the mysql connections, means, i get error messages because the number of max_user_connections become exceeded. Since i disactivated this plugin, everything works fine again.

    http://wordpress.org/extend/plugins/adrotate/

  2. Arnan de Gans
    Member
    Plugin Author

    Posted 10 months ago #

    Every connection AdRotate makes to MySQL goes through $wpdb (The wordpress database class).

    http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

    A common thing that happens on cheap shared hosting is that the webhost puts too much people on the same server or shares users/mysql instances across multiple users. This will work against you in many ways, one of which a stupidly small pool of connections.

    Talk to your webhost about lifting or removing the limitation. Or better yet, upgrade to something better than what they offer.

  3. simpson-fan
    Member
    Posted 10 months ago #

    Sorry for that post. It was not AdRotate causing the troubles. It was the W3 Total Cache plugin.

  4. Arnan de Gans
    Member
    Plugin Author

    Posted 10 months ago #

    Isn't W3 Total Cache designed to lessen overall queries?

  5. Frederick Townes
    Member
    Posted 10 months ago #

    No it's not designed for it, it can if you choose to and it's possible. Caching plugins are not a silver bullet, instead they allow you to take your hardware to its limit.

    Anyway, caching pages will reduce the work PHP and MySQL have to do, but low traffic sites will often remain uncached without priming being used.

    If you write me about specific issues with your site we'll be able to help.

  6. Arnan de Gans
    Member
    Plugin Author

    Posted 10 months ago #

    Frederick - So his site is/was likely not optimized/configured very well with your plugin then?
    Or how should I see that?

  7. Frederick Townes
    Member
    Posted 10 months ago #

    Yes, basically. Unfortunately, there are some starting points, but a fully optimized site requires some testing and investigation.

Reply

You must log in to post.

About this Plugin

About this Topic