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,
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 wrote
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 these
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 SQL
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.
--
Jeremy
