The Arcive of vBulletin Modifications Site. |
|
Getting an error (max user connections) Details »»
|
|||||||||||||||||||||||||
Getting this error:
mysql_connect(): User XXXXXX_XXXXXXX has already more than 'max_user_connections' active connections /home/XXXX/public_html/XXXXX/includes/class_core.php on line 271 What could be the problem? Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
|||
|
|||
|
You need to contact your host. You have exceeded the simultaneous connections limit on your server.
|
|
#3
|
|||
|
|||
|
Weird. I had 296 people on the site at one time back in July and there was no problem. Yet, today I get these errors via e-mail when there are only 70 people on site.
|
|
#4
|
|||
|
|||
|
you are most likely on a shared host. consider moving to another host if they don't want to change this number.
|
|
#5
|
||||
|
||||
|
IMO its sql problem.
its just crossed Max connections limit. u can contact your host admin. if ur a shared host...i gez they dont have much to do. |
|
#6
|
|||
|
|||
|
If they don't knwo what to do tell them to take a look at the /etc/my.cnf file and change the max connections there.
|
|
#7
|
||||
|
||||
|
You may be able to create more MySQL users and have vBulletin connect to a random one each time.
|
|
#8
|
||||
|
||||
|
Adrian,
Are you talking about using multiple databases? Can you go into a bit more detail on that? I am getting lots of database errors and my host, 1and1.com, says it's because I am only allowed 18 concurrent database connections. That doesn't sound right. Eighteen isn't very many. They say they can't do anything about it, so I thought about looking for a new host with better real limits. Thanks, Jim (a happy vBlogetin user) |
|
#9
|
||||
|
||||
|
No, accounts with privileges to the same database. If a random account is selected (say, from 5 accounts) each time, then you should be able to handle 5x as many connections.
|
|
#10
|
||||
|
||||
|
Thanks, Adrian. Could you point me to some instructions or someplace I can get guidance setting something like that up?
Jim |
![]() |
|
|