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: > 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, closing table, ...) that is used for > the amount of time ? Both, really. I can't think of a time when one changes but the other does not. > 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. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 11 days, processed 431,850,739 queries (420/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]