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