Hi, If you are using mysql_pconnect, your connections will not be closed at the end of the script, even if mysql_close is used.
Regards, Jocelyn ----- Original Message ----- From: "cristian ditoiu" <[EMAIL PROTECTED]> To: "Dan Nelson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 2:33 PM Subject: Re: sleeping threads problem > Nope , you haven't read my email . > I use PHP and MySql . Php closes mysql connections when the script ends . > And the script ends every time a user hits a page . > http://www.php.net/manual/en/function.mysql-close.php Quote : 'Using > mysql_close() isn't usually necessary, as non-persistent open links are > automatically closed at the end of the script's execution' > > ----- Original Message ----- > From: "Dan Nelson" <[EMAIL PROTECTED]> > To: "cristian ditoiu" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, December 03, 2002 7:27 PM > Subject: Re: sleeping threads problem > > > > In the last episode (Dec 03), cristian ditoiu said: > > > Hello , i use MySql 3.23.49-log with Php 4.2.1on RH 7.2 . > > > The problem is that i got many many (16-30) sleeping threads almost all > the > > > time . The code is pretty clean , and i suspect > > > that those threads are sleaping beacuse of some strange ascii characters > > > (like CR) . > > > Is any intelegent way to find out WHY are those threads sleeping ? > > > > They are sleeping because you have not given them a query to process. > > Sleeping threads are idle connections. > > > > -- > > Dan Nelson > > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > 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 > > > --------------------------------------------------------------------- > 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 > > > > --------------------------------------------------------------------- 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