Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 04 May 2009 00:35:11 +0930
From:      Wayne Sierke <ws@au.dyndns.ws>
To:        Zbigniew Szalbot <z.szalbot@lcwords.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: mysql hiding from top
Message-ID:  <1241363111.8180.21.camel@predator-ii.buffyverse>
In-Reply-To: <dbdfb102e213cc2923eb75a56243dac7.squirrel@relay.lc-words.com>
References:  <dbdfb102e213cc2923eb75a56243dac7.squirrel@relay.lc-words.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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".





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1241363111.8180.21.camel>