Results 1 to 5 of 5

Exceeding MySQL connection limit

This is a discussion on Exceeding MySQL connection limit within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Hi there, Since re-installing vBSEO (Our license was expired for quite a few months) we have noticed that we get ...

  1. #1
    Junior Member
    Real Name
    RichM
    Join Date
    Oct 2006
    Posts
    11
    Liked
    0 times

    Exceeding MySQL connection limit

    Hi there,

    Since re-installing vBSEO (Our license was expired for quite a few months) we have noticed that we get the following error more frequently:

    Database error in vBulletin :

    mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: User xxxxx_forum already has more than 'max_user_connections' active connections
    /home/xxxxx/public_html/includes/class_core.php on line 311

    MySQL Error :
    Error Number :
    Request Date : Friday, February 13th 2009 @ 03:14:56 PM
    Error Date : Friday, February 13th 2009 @ 03:14:56 PM
    Script : SlicedThread - Laskavo Prosymo!
    Referrer :
    IP Address : 92.19.142.xxx
    Username :
    Classname : vB_Database
    MySQL Version :
    Are there any vBSEO features which could contribute to this? If so, which would you suggest I disable? Obviously I'd like to take advantage of vBSEO as much as possible.

    Cheers

    - Rich

  2. #2
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    23,111
    Liked
    622 times
    Blog Entries
    4
    Hello Rich ,

    The above error is not related to vBSEO. You need to increase max_user_connections and restart apache. It is related to the traffic you face.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  3. #3
    Senior Member
    Real Name
    Holger
    Join Date
    Oct 2005
    Location
    Frankfurt / Germany
    Posts
    611
    Liked
    1 times
    You need to increase max_user_connections and restart apache
    restart apache? restart mysql

    regards

  4. #4
    Junior Member
    Real Name
    RichM
    Join Date
    Oct 2006
    Posts
    11
    Liked
    0 times
    Quote Originally Posted by fsb-holger View Post
    restart apache? restart mysql

    regards
    It's a shared server. + I don't think that'd be a long term solution.

    Our host gave us the following suggestion:

    Quote Originally Posted by Asmallorange

    One other thing, it looks like your software is set to use persistant mysql connections ( mysql_pconnect() ). Try disabling this and letting the connections get created when the request is needed.
    Any idea how to do this?

    Cheers

    -Rich

  5. #5
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    23,111
    Liked
    622 times
    Blog Entries
    4
    You can do that from config.php

    PHP Code:
        //    ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
        //    This option allows you to turn persistent connections to MySQL on or off.
        //    The difference in performance is negligible for all but the largest boards.
        //    If you are unsure what this should be, leave it off. (0 = off; 1 = on)
    $config['MasterServer']['usepconnect'] = 0
    Surely mysql Holger Typed wrong.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

Similar Threads

  1. MySQL to launch new features only in MySQL Enterprise
    By Mert Gökçeimam in forum Off-Topic & Chit Chat
    Replies: 3
    Last Post: 04-17-2008, 11:19 PM
  2. Lost connection
    By Ghostsuit in forum Troubleshooting
    Replies: 2
    Last Post: 03-07-2006, 03:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •