Announcement

Collapse
No announcement yet.

too many connections & slow running

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • too many connections & slow running

    hi all,
    im having serious issues with my forum at present..(see title)
    the main one being the forum is so slow taking upwards of 30 seconds sometimes to refresh a page after an edit/post/navigation..
    Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
    /homepages/xx/xxxxxxxxxx/xxxxxx/xxxx/includes/class_core.php on line 279
    my users are getting almost as annoyed as me..
    i also get 'too many connections' errors reported by vB..
    ive attached a txt file showing mySQL configuration as reported by CP..
    any advice greatly appreciated..
    nik
    vb3.5.4 (ahem..still)
    Attached Files

  • #2
    1. The server has maxed out the number of MySQL connections it allows. This is a server-wide limit, not just your forums. You can try turning persistent connections off in your config.php:

    $config['MasterServer']['usepconnect'] = 0;

    But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.

    Here is more info on that error:

    http://dev.mysql.com/doc/refman/5.0/...nnections.html

    2. Please see this thread for help with optimizing your server:

    http://www.vbulletin.com/forum/showt...threadid=70117

    Then post the requested info in a new thread in that forum.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      WOW a server-wide limit..of 240...!!!

      thanks for the timely advice steve..

      Comment

      Loading...
      Working...
      X