Too many connections - database error

[induslady]

Hello,

Sorry about opening a new thread on this subject - too many connections error. I did check the other threads in this subject but could not find a solution and hence opened this thread.

I have my hosting company set the max limit as 50000 user per account. My forum site is not too big, roughly 1500 members and about 10 to 15 guests at any point of time. I am sure the number of users connected to the database at any point of time will not exceed 50000.

But I am receiving the vbulletin database error - too many connections.

I have also included $config['MasterServer']['usepconnect'] = 0; this in the config.php.

Please let me know what needs to be done at the MySQL database to fix this isse.

Thanks in advance,
Induslady

[MrOnline]

just a question out of the blue

have u asked your isp/serverhost about the limits on the sql ??
They might have a lower limit than you "think" they have

[induslady]

Is sql limit different?

Hi,

Thank you for your response.

My hosting company mentioned about 50000 as the max limit on the server per account (I am using a shared server).

Is the sql limit a different number?

Please let me know.

Regards,
Induslady

[ComputerVitals]

Ask your host how many persistant connections to the database you can have.

Also look at how many bots you have crawling. Could also be any mod that isn't closing a table.

[Klepto]

This is the same problem I have, I think its a mod not closing down a table. In fact i think i know which mod it is. How can i fix it?

[Zachery]

Are you sure its max connections and not max questions?

[Klepto]

Database error in vBulletin :

mysql_connect(): Too many connections
/home/domain/public_html/forum/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Tuesday, April 24th 2007 @ 12:12:10 PM
Script : http://domain/forum/cron.php?&rand=19121
Referrer : http://domain/forum/index.php
IP Address : xxxx
Username :
Classname : vb_database

[Zachery]

Its possible that there are too many connections globally for the server, if your host had imposed a limit the error would be more specific.

[Klepto]

I havent had this problem until I installed a mod not too long ago. So I doubt its my host, unless of course just recently they are having too many connections globally.

I would just uninstall the mod and be done with it, but I love the mod, its the arcade.

[Klepto]

Oh and my "persistant connections" are set to "0"

[Zachery]

Its quite possible its your host.

[Steve Machol]

It is, in fact, the server. This is for all MySQL connections, not just yours. You need to contact your host about this.

[radali]

Today I have got this error

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home2/soltanz/public_html/forum/includes/class_core.php on line 312

I'm on dedicate server, without limits , what's the problem?

[Alfa1]

Look in phpinfo and check how many max_connections you have.