Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Our MySQL always ends up in this state at some point... SHOW PROCESSLIST shows nothing in the queue, so why does this say it's been running for 193 hours?

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                                           
 2785 mysql     20   0  133m  45m 5808 S    6  0.3 193:58.50 mysqld 
share|improve this question

1 Answer 1

up vote 1 down vote accepted

You've misinterpreted the TIME+ field. That is not how long it's been "running for", that is a figure of used CPU time. Check out this Wikipedia article for specifics: http://en.wikipedia.org/wiki/CPU_time

share|improve this answer
    
Also, that is the MySQL daemon that has used up a total of 194 hours of CPU time for all the work it has done, rather than a single query execution time, which is what the title of the question seems to imply! –  Dave Rix Oct 25 '11 at 10:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.