Too many open connections

[Mark Hewitt]

I'm starting to get 'too many open connections' error now and again. As I am on a virtual hosting account I'm not sure what I can do about this - if anything.

Is there some appropriate questions I can put to my host?

[doron]

is vB the only mysql script on your account? Ask your hsot to check what script is causing them

[Mark Hewitt]

I saw the errors for myself they happened when I tried to perform a vBulletin operation.

[doron]

most hosts limit the connections allowed from one account at any particular time. What could be is that another script is taking too many connections.

[jeffyen]

I'm getting 500 internal server errors lately, don't know whether it's because of 'too many open connections' though.

Is there a problem when lots of users load the forum at the same time? Will it somehow cause the script to unload itself or something?

[Mark Hewitt]

if there is too many connections then it says too many connections.

I think the 500 errors are likely to be something else. Do they happen all the time or just now and again?

[jeffyen]

It happens irregularly.

What exactly does 'open connection' mean? Does it mean a single user doing an mysql query, or does it mean a single mysql script on the virtual host?

[bira]

Mark, you have to find out what your MySQL variables are - how much is says for max_connections, if you get this error your host may need to up them. Also, you may want to open admin/db_mysql.php (in your BB dir) and change mysql_pconnect (in both instances) to mysql_connect. That would lower your maximum connections.