First of all, thank you Jeremy for your answer.
You said:
>> It's the amount of time that thread has been in its current state.
Is it the current state column value (which is in fact nothing or the text of the
running SQL request)
or the current command column value (sleeping, opening table, cl
Thanks very much.
Marc.
-Message d'origine-
De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 13 août 2003 17:01
À : Mechain Marc
Cc : [EMAIL PROTECTED]
Objet : Re: Meaning of Column time in Show Processlist
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc
Jeremy Zawodny wrote:
>
>> What happens to the thread if the value of time is greater than
>> interactive timeout or wait timeout ?
>
>The client will be disconnected and thread closed.
That's what I thought was supposed to happen, but we constantly wind up
with sleeping connections longer than t
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc wrote:
> First of all, thank you Jeremy for your answer.
>
> You said:
>
> >> It's the amount of time that thread has been in its current state.
>
> Is it the current state column value (which is in fact nothing or
> the text of the running
On Tue, Aug 12, 2003 at 11:43:50AM +0200, Mechain Marc wrote:
>
> I would like to know (if possible, there is no explanation in the
> documentation) the exact meanning of the column "time" in the "show
> processlist" command.
It's the amount of time that thread has been in its currnet state.
--
J