mysql hiding from top

[Zbigniew Szalbot]

Hi there,


> The process is sleeping-- perhaps it isn't using enough CPU to make it
> into the list using default sort ordering?  Try "top -o time",
> perhaps....

No, this is a different issue. Take a look:

  PID USERNAME  THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
88268 www         1  47    0 40260K 29336K select 2   0:03  2.49% httpd
89632 www         1  44    0 33648K 23352K CPU0   0   0:00  0.78% httpd
89290 www         1  20    0 25456K 17760K lockf  2   0:01  0.68% httpd
89074 www         1  44    0 26384K 17696K select 2   0:00  0.20% httpd
32906 mysql      37   4    0 76636K 41664K sbwait 1   0:00  0.10% mysqld

It does appear at times but it is showing 0:00 TIME. But compare it to the
same mysql pid below:

$ ps ax |grep mysql
32906  p0- S      1:41.77 /usr/local/libexec/mysqld

This is what I find strange... :)


-- 
Zbigniew Szalbot