List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:July 7 1999 11:02am
Subject:Processlist
View as plain text  
>>>>> "Kevin" == Kevin Smith <kevin@stripped> writes:

Kevin> Hi All,
Kevin> Can anyone tell me if the processes listed below that have a time over 
Kevin> 4000 is this something to worry about, or, is this normal?

Kevin> The strange thing is there aren't any processes running at the time I ran 
Kevin> this?  And does the command Sleep have any significance besides the 
Kevin> obvious?


mysql> show processlist;
Kevin> +------+-------+------------------------+--------------+---------+------+--
Kevin> -----+------------------+
Kevin> | Id   | User  | Host                   | db           | Command | Time | 
Kevin> State | Info             |
Kevin> +------+-------+------------------------+--------------+---------+------+--
Kevin> -----+------------------+
Kevin> | 1081 | ogola | userca77.uk.uudial.com | playerselect | Sleep   | 5514 | 
Kevin> NULL  | NULL             |
Kevin> | 1082 | ogola | userbl68.uk.uudial.com | playerselect | Sleep   | 5432 | 
Kevin> NULL  | NULL             |
Kevin> | 1091 | ogola | userai20.uk.uudial.com | playerselect | Sleep   | 4846 | 
Kevin> NULL  | NULL             |
Kevin> | 1204 | root  | localhost              | playerselect | Sleep   | 32   | 
Kevin> NULL  | NULL             |
Kevin> | 1221 | root  | localhost              | playerselect | Query   | 0    | 
Kevin> NULL  | show processlist |
Kevin> +------+-------+------------------------+--------------+---------+------+--
Kevin> -----+------------------+
Kevin> 5 rows in set (0.01 sec)

Hi!

'sleep' means that the thread is idle (doesn't do anything).  It's
just waiting for the connected client to send it some SQL command to execute.

Regards,
Monty
Thread
ProcesslistMichael Widenius7 Jul