Hosting says i have lots of mysql opened causing server to delay

[iBuddy]

I noticed my hosting said that my sites were going down because I have lots of mysql connections opened. I'm wondering if there is something im not fully coding right not prevent any distraction from a overload to the server. When I connect to a mysql I usually leave it open for the entire page in case i have to reference it. I have under 10 databases open with about 5 diff username & password for mysql to connect with. Can anyone let me know what I can do to make my coding more effecient to the hosting service to prevent downtime and the server being rebooted. I love using mysql and its so damn convenient, I try to formulate everything in mysql but im wondering if this is a bad idea now.

Hope to hear some feedback-thanks.

[planetsim]

You have way too many databases.

How many tables per database?

[swr]

If you're using [man]mysql_pconnect[/man], try using [man]mysql_connect[/man] instead.

Persistent connections are good if you only have one site on the server and its only using a single database, but in a hosting environment most of the httpd processes will be serving other customer's sites and if they are still holding a connection to your database it's just a waste.

[nightowl]

changing the pconnect by connect is good if the databas and webserver are on the same machine - otherwise: you may consider still using pconnect but cutting down on the databases.

[drawmack]

I cannot think of a single logical reason to use that many databases on a single site.