Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 27 Apr 2009 17:11:11 +0000
From:      Paul Schmehl <pschmehl_lists@tx.rr.com>
To:        Zbigniew Szalbot <z.szalbot@lcwords.com>, freebsd-questions@freebsd.org
Subject:   Re: mysql hiding from top
Message-ID:  <720E9A87F95E44B452BF93E9@utd65257.utdallas.edu>
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 Monday, April 27, 2009 11:49:55 -0500 Zbigniew Szalbot 
<z.szalbot@lcwords.com> 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?
>

Top doesn't show *all* processes.  It shows the processes using the most cpu 
(by default.  You can also display by io.)  So, if mysqld isn't using a lot of 
cpu, it's not going to show up in the list.  You might be able to force it to 
show up by giving top a number (of processes you want to see) that includes 
enough that mysqld will show up.

-- 
Paul Schmehl, Senior Infosec Analyst
As if it wasn't already obvious, my opinions
are my own and not those of my employer.
*******************************************
Check the headers before clicking on Reply.




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