Processlist

[Michael Widenius]

>>>>> "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