Getting constant connection errors.

[1yesfan]

The last couple days I have been seeing this....

Database error in vBulletin :

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

MySQL Error :


My server folks have went in and reset and raised my connection...

"have restarted the mysql service, make sure in your coding that you are closing connections to mysql, as you can only have so many open before you get this error. And this could be a cuase."

They are saying I need to make sure my code is closing connections???? How do I check for that?

Tim

[Jake Bunce]

Make sure pconnect is off in your includes/config.php file:

	//	****** 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;

If this is currently set to 1 then changing it to 0 might help the problem. Otherwise you need to get your host to increase the connection limit.

[1yesfan]

Ok, it was on 1 so I set it to 0. Thanks!

[1yesfan]

What did this do for me?

[Jake Bunce]

It will now drop each database connection when the request is done. You won't notice any difference on your forum. Hopefully this will prevent you from reaching the connection limit again.

[1yesfan]

What are the pro's and con's of this being set to 1 or 0?

[Jake Bunce]

On busy forums the persistent connections can reduce load on the database server I think.