persistence connection problem

siri_suresh

Hi all,
I am using apache1.3.22,php4.1.1 with oracle8 and OS is solaris as well as WINDOWS 2000. I am using the persistence connection(PHP) for update/insert/select to the database. The apache server is opeing a child process and holding connection(one connection per child) on every database transaction. For every request the connection is opening to database and it is not getting closed. As per PHP document(Pl refer the PHP doc on persistence connection) the child created by apache, holds the persistence connection until it die(child). But for every request the apache is crating the child(i am asuming... because it is opening databse connection every time) and it is trying to hold the database connection even the remaining childs are free(not doing any thing). After some time all of my database connections are in use and giving error "MAX number of connections exceeded".

How can i over come this problem, But i have to user persistence connection mechanisum of PHP?

Pl help me. Thanks in advance.

Bye
Suresh

trooper

Any particular reason you are using a persistant connection ?

siri_suresh

Hi
Gary Mailer,

Ya, my data base may be in other system so that the database connection time will be reduce using the persistence connection mechanisum(OCIPlogin).

Thanks
Suresh

trooper

I had this same issue of maximum connections exceeded in the past. I was using the normal connect not pconnect. I foun out that no where is my scripts was i using a mysql_close() statement. THe thing is with pconnect that it doesn't close the connection when the script ends, hence your message.

Not having used pconnect before i'm not 100% sure what you should do (short of using mysql_connect() / mysql_close() instead.

My guess is that there is a setting in the php.ini file specifying how long a pconnect is to last.

Found this in a post
pconnect only lasts as long as the server side process lasts. So the connection will be broken as soon as the resulting information from the server side process is sent to the browser.

http://www.phpbuilder.com/forum/read.php3?num=5&id=9031&thread=9013

Gary