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

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.

You need to increase max_user_connections and restart apache

restart apache? restart mysql

regards

Originally Posted by fsb-holger

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:

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

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.