How do I fix the "Too many connections" error?

[Johnny Doomo]

Every few days I am getting the

Warning: mysql_connect(): Too many connections in /home/user/public_html/gallery/pp-inc.php on line 71
I cannot connect to the PhotoPost database. []

How do I get rid of this error? Is there a place in the PP code that is saying how many connections it will accept and can I change it without it affecting stuff too much? If you can tell me where this number is so I can start to play with it and get it set right for my server I would be a happy camper.

Thank you.

[Chuck S]

You would need to contact the host about this as it is a server issue and not one of the photopost software.

[Johnny Doomo]

I have my mysql connections set to like 300, maybe more. This is getting a little crazy. How many mysql connections should a dual xeon box allow?

[Chuck S]

A quick fix is to restart the MySQL server which clears the overload of connections but does not prevent it from happening again. Analysis of load and configuration settings is needed to devise a permanent solution.

I do not run a dedicated server so sorry I do not know what is the norm.