[RESOLVED] too many open connections - quick fix?

BEFOR

My host tells me there are too many open connections (not totally convinced of what he is saying - maybe any loops that aren't closed?) which is whay my site appears to not come up at times.

Is there a general/all purpose snippet that can be placed near the foot of the page that will ensure that any "open connection" is closed as a result of the script on the page?

NogDog

What type of "connection" are we talking about here?

BEFOR

All I know is that they are saying the php isn't closing out after the page is left

BEFOR

Sorry for the double reply - have been trying to reach my host, and am cannot edit my prior post.

From my notes, specifically host said

there are too many simultaneous connections. make sure php scripts are properly terminating when not running.

they are opening but not terminating (on some pages).

Other than that, will have to contact them monday.

NogDog

Normally PHP scripts should close everything upon completion. An exception is certain types of "persistent" connections, usually for database connections such as those created by mysql_pconnect(). I would recommend not using mysql_pconnect() but rather mysql_connect() (unless you really know why you're using a persistent connection and understand all the ramifications).

If on the other hand the problem is that the script itself is not terminating, that should really be addressed directly to find out why. You could make sure that the ignore_user_abort setting is off, which might help a little if scripts are hanging, though I wouldn't really count on it.

BEFOR

Nog Dog,

Much appreciate your post.

Searched and found I am using mysql_pconnect()
right in a connection script:

$hostname_a = "";
$database_a = "";
$username_a = "";
$password_a = "";
$a = mysql_pconnect($hostname_a, $username_a, $password_a) or die(mysql_error());

But you know, I have several sites with this host and they all use mysql_pconnect()

How do I find out if the "p" can be removed other than simply testing it?
Is there a type of script that requires it?
(Dreamweaver may have put it there)

As for ignore_user_abort it is Off

dagon

BEFOR;10908994 wrote:
How do I find out if the "p" can be removed other than simply testing it?

Persistent Database Connections

An important summary. Persistent connections were designed to have one-to-one mapping to regular connections. That means that you should always be able to replace persistent connections with non-persistent connections, and it won't change the way your script behaves. It may (and probably will) change the efficiency of the script, but not its behavior!

BEFOR

thank you dagon