Re: Persistent Connections

Not sure about others, but we get this sometimes on a particular setup where I have the Apache process kill itself after x connections. My theory is that my apache is dying, but the mysql side keeps holding that open connection. The default Mysql connection holding time is 28800 seconds I think, which is, what?, 8 hours? Try reducing the mysql connection hold open time, and see if that helps. Victor wrote: > Yes, I am using MySQL. But why do the connections overrun the pool that > mysql offers ? It should be fine with 5 persistent connections or 10 or even > > 20. But if left on, it consumes ALL connections given out by mysql. I did > raise the number from 100 to 150, with no result. The new connections were > taken and I was again left with no connections. Why do the programs not > reuse existing connections ??? > > Any ideas ? > > idban secandri wrote: > > > At 15:07 27/06/00 -0400, you wrote: > > >How exactly does the persistant connection setting in PHP work? If I > > >allow unlimited number of persistent connections, they never die and > > >don't seem to be reused. I run phpAds, and constantly the number of > > >connections overrun. > > > > you mean mysql connection ?? if yes make your max connect up to 100 > > i du have problem like this when my mysql set by default 100 connections > > > > just change your mysql max connection ( rean again the manual of mysql ) > > > > -- > > Doubt whom you will, but never yourself. > > http://php.klik.or.id > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- ========================== Michael Kimsal http://www.tapinternet.com 734-480-9961