mysql hiding from top

[Paul Schmehl]

--On Monday, April 27, 2009 11:49:55 -0500 Zbigniew Szalbot 
<z.szalbot at 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.