On Sun, Jun 23, 2002 at 08:02:45PM +0100, Paul Roberts wrote :
> php will close the connection when the script finishes unless
> you are using mysql_pconnect which opens a persistent
> connection.
Yup, ever resource besides persistent ones are cleaned up
upon script termination.
> From: "Joseph Bueno" <[EMAIL PROTECTED]>
> To: "Markus Fischer" <[EMAIL PROTECTED]>
> mysqld uses threads (you already found the right documentation).
>
> > How long is the life-time of a connection if there's no
> > request comming anymore? The mysqld is acesssed with PHP and
> > I'm using normal mysql_connect() so connections aren't
> > persisten so they should go after some time?
> >
> >
>
> The thread is created when a client opens a new connection and destroyed
> when the client closes the connection (unless you explicitely ask mysqld
> to keep some of them, see 'thread_cache_size' server parameter).
Ok, I do not use thread_cache_size and looking into the mysql
documentation the default thread_cache_size is 0. Since PHP
then closes the connection, how is it possible that there are
about 22-24 threads running? This site is my all means not a
busy site. If I check the sql log it takes up to 5 to 10
seconds before a new query occurs which means that I seldomly
get two connection attempts in the same second ...
It doesnt seem to exceed the 24 limit though.
just curious and thanks for the inforamtion,
- Markus
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
