Log in

View Full Version : Database Error 3.8


SVTCobraLTD
11-07-2011, 11:41 AM
What can I do to stop these. Lately, I have been getting a few a day.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/xxxx/xxxxx/forums/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Monday, November 7th 2011 @ 06:35:16 AM
Error Date : Monday, November 7th 2011 @ 06:35:16 AM
Script : http://www.xxxxxxx.com/forums/admincp/user.php?do=edit&u=2166
Referrer : http://www.xxxxxxx.com/forums/admincp/user.php?do=find&user[usergroupid]=8
IP Address : xxxxxxxx
Username :
Classname : vB_Database
MySQL Version :

HMBeaty
11-07-2011, 03:45 PM
https://vborg.vbsupport.ru/showthread.php?t=272014

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off in your config.php:

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

But if you still have problems after that, you will need to raise this limit. Here is more info on that error:

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

SVTCobraLTD
11-07-2011, 06:12 PM
Persistent connections is already off.

mysql.connect_timeout I changed to 20 instead of the default 60 after reading that thread you linked to. Is this a bad idea?

Is there a mod that will limit robot access if connections are too much?

souperman
11-07-2011, 10:38 PM
You made it worst. Try increase it, but make sure you have the hardware for it.

SVTCobraLTD
11-08-2011, 10:54 AM
You made it worst. Try increase it, but make sure you have the hardware for it.

Changed it to 80.