Database connection

[stephen]

Every now and then my site comes up with an error saying there is too many connections to the database.

My code is setup so when I need something it connects to the database, selects the table, does what it needs to, then closes the database connection.

It does not happen very often but I have seen it from time to time.

Is this from me opening and closing so much? should I have it opened all the time? or should I have and include file that has all the database connection information?

Just looking for some advise.

Thanks

[[deleted]]

It simply means that your database server get's more connection requests than it is allowed to handle.

If you are alone on that server, you should be worried
and start looking at just how many connections you open at the same time.

If you are sharing the server with other clients, you should talk to your sysadmin and ask if he can increase the number of connections for the database server.

[kaustubhhere]

I think u should talk to your hosting company or your system administrator about this as it seems like there are too many people sharing the database server at the same time, your host either needs to increase the number of connections or increase bandwith by moving some users to another server.

thanks,
kaustubh

[stephen]

thanks for the advice. I contacted my tech support and told him the situation. This is what he replied.

---

A few clients were using the command mysql_pconnect that creates a persistant mysql connection. He said he would get that corrected, he also said he placed a script in cron that will kill persistant connections.

He concluded by saying that if I still get the errors in the future that he would move me to a server with fewer databases.

So it looks like I may have things solved
Thanks for all your help and advice.

Stephen