Getting an error (max user connections)

[SRO]

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?

[peterska2]

You need to contact your host. You have exceeded the simultaneous connections limit on your server.

[SRO]

You need to contact your host. You have exceeded the simultaneous connections limit on your server.
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.

[Hornstar]

you are most likely on a shared host. consider moving to another host if they don't want to change this number.

[Zia]

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.

[jugo]

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.

[Adrian Schneider]

You may be able to create more MySQL users and have vBulletin connect to a random one each time.

[eJM]

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)

[Adrian Schneider]

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.

[eJM]

Thanks, Adrian. Could you point me to some instructions or someplace I can get guidance setting something like that up?

Jim

[Marco van Herwaarden]

See http://www.vbulletin.com/forum/showthread.php?p=1160827&highlight=random%28#post1160827

[eJM]

<i>Excellent</i>, thank you, Marco.