Re: [PHP-DB] PHP/Apache not totally closing MySQL connections From: Andreas D. Landmark (andreas.landmark <email protected>)
Date: 11/18/01

At 18.11.2001 06:36, Bob Maple wrote:
> > >Proto Recv-Q Send-Q Local Address
> > >tcp 1 0 burner.com:4848 burner.com:mysql CLOSE
> >
> > [munge-alert!]
>
>Hmm, looks like my pastes got whacked. Oops.
>
> > nope, if you leave it going for awhile nothing out of the ordinary
>happens,
> > the socket will be reused (when it's time is up).
> >
> > the reason it doesn't "go away" until Apache is closed is that this is
>apache's
> > socket, and not MySQL's, as the forreign address is the :mysql.
>
>OK, thanks -- I did some rapid refreshes of a page and indeed, the 'CLOSED'
>state sockets ultimately are being recycled. I guess I just wasn't getting
>the same httpd process that had them open before, because at one point I had
>about 5 of these sockets hanging around while new connections continued to
>appear.

that's because you're running more than one apache process, the number of
closed sockets should be proportional to the number of apache processes
(as set by httpd.conf). 

-- 
Andreas D Landmark / noXtension
Real Time, adj.:
         Here and now, as opposed to fake time, which only occurs there
and then.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>