mysql hiding from top

[Wayne Sierke]

On Mon, 2009-04-27 at 18:49 +0200, Zbigniew Szalbot wrote:
> hello,
> 
> Today I have finally upgraded my system to 7.1-RELEASE and just noticing
> that mysql process is not being shown via the top command.
> 
>   PID USERNAME  THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
>  1612 root        1  20    0  9212K  6716K pause  2   0:26  0.00% perl5.8.9
>   966 www         1   8    0  8236K  5452K nanslp 2   0:22  0.00% perl5.8.9
>  1594 root        1  20    0  8740K  6220K pause  0   0:12  0.00% perl5.8.9
> 
> However, if you grep processes, you can see it should be displayed in the
> top entries.
> $ ps ax |grep mysql
> 32880  p0- I      0:00.00 /bin/sh /usr/local/bin/mysqld_safe...
> 32906  p0- S      1:33.72 /usr/local/libexec/mysqld...
> 
> I can live with that but maybe there's some explanation for this?
> 
> Thanks!
> 
>From the manpage for top(1):
        FreeBSD NOTES
        DISPLAY OF THREADS
               The  '-H'  option will toggle the display of kernel visible thread con-
               texts.  At runtime the 'H' key will toggle this mode.  The  default  is
               OFF.

Should reveal the "missing" thread(s). This was raised by someone else
last November also examining mysqld. Look for a thread titled "top
incorrectly reporting process time".