List:General Discussion« Previous MessageNext Message »
From:Jocelyn Fournier Date:December 4 2002 4:06pm
Subject:Re: sleeping threads problem
View as plain text  
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" <cristian.ditoiu@stripped>
To: "Dan Nelson" <dnelson@stripped>
Cc: <mysql@stripped>
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" <dnelson@stripped>
> To: "cristian ditoiu" <cristian.ditoiu@stripped>
> Cc: <mysql@stripped>
> 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
> > dnelson@stripped
> >
> > ---------------------------------------------------------------------
> > 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 <mysql-thread126436@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-cristian.ditoiu=netbridge.ro@stripped>
> > 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 <mysql-thread126538@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>

Thread
sample "c" code wantedTom Roos3 Dec
  • sleeping threads problemcristian ditoiu3 Dec
    • Re: sleeping threads problemDan Nelson3 Dec
  • Re: sleeping threads problemcristian ditoiu4 Dec
  • Re: sleeping threads problemJocelyn Fournier4 Dec