PDA

View Full Version : mysql database error


dlewisr
07-23-2011, 06:50 PM
For the last couple of days I have been receiving the email below. Can anyone explain what this means and how to get solve the issue.

Cheers in advance.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxx admin already has more than 'max_user_connections' active connections
/home/xxxxxxx/public_html/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Saturday, July 23rd 2011 @ 12:22:28 PM
Error Date : Saturday, July 23rd 2011 @ 12:22:28 PM
Script : http://www.xxxxxxxxxx.co.uk/forum.php
Referrer :
IP Address : xxxxxxxxxx
Username :
Classname : vB_Database
MySQL Version :

Lynne
07-23-2011, 07:04 PM
The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:
$config['MasterServer']['usepconnect'] = 0; But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages (https://www.vbulletin.com/docs/html/troubleshoot_mysql_errors)

dlewisr
07-23-2011, 07:49 PM
Thank you Lynne. That is already added to my config. I have just received an email from the Host Papa

We allow up to 15 simultaneous connections per MySQL user, and up to 150 simultaneous connections per server.

Fifteen connections are more than enough for most sites. Most connections are only open a fraction of a second, so 15 simultaneous connections is usually sufficient, even for a forum (for example) with hundreds of members.

It's a very small forum that I have with only 60 members!

Videx
07-24-2011, 12:53 AM
Reminds me of my Bad Old Days on HG. What they didn't tell you in that email is that if they oversell their shared servers then each connection stays open way longer than it should, and this error can result. You want to look to the server load, and try complaining about that. Good Luck - they'll probably just try to sell you a "less shared" server like a VPS.

dlewisr
07-24-2011, 04:42 PM
They haven't been any help at all really, as with other issues. It's frustrating as I asked lots of questions such as server load before I signed and was reassured that they fitted all of my needs. You hit the nail on the head, as they have suggested I move to a VPS server, which they don't provide and I have prepaid for 3 years!

Thanks for the reply Videx

silver.fox1969
11-22-2011, 06:52 PM
Just want to find out how you got on with this error as im getting the same problem and my host allows 10 connections per MySQL on my small forum.

CILGINKRAL_
03-01-2013, 08:45 AM
Lynne (https://vborg.vbsupport.ru/member.php?u=65230) thank you ;)