Re: mysql hiding from top

2009-05-03 Thread 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 SIZERES STATE C TIME WCPU COMMAND > 1612 root

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
> True, although if it's readily reproducible, it would be good to fix. I'd be happy to test but I do not know what to do/where to start. I know it is a permanent issue, because I even restarted the mysql server thinking that something is wrong that it is not being shown in top but the history rep

Re: mysql hiding from top

2009-04-27 Thread Paul Schmehl
--On Monday, April 27, 2009 11:49:55 -0500 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 SIZERES STATE C TIME WCPU COMMAND 1612 root

Re: mysql hiding from top

2009-04-27 Thread Chuck Swiger
On Apr 27, 2009, at 10:33 AM, Zbigniew Szalbot wrote: Ah-- I've heard rumors that top or something doesn't handle accounting for CPU time used by multithreaded processes very well... OK. Well I have never had any problem with that on FreeBSD 7.0- RELEASE. It started misbehaving today right a

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
> Ah-- I've heard rumors that top or something doesn't handle accounting > for CPU time used by multithreaded processes very well... OK. Well I have never had any problem with that on FreeBSD 7.0-RELEASE. It started misbehaving today right after an upgrade to 7.1-RELEASE. Like I said, I can really

Re: mysql hiding from top

2009-04-27 Thread Chuck Swiger
On Apr 27, 2009, at 10:22 AM, Zbigniew Szalbot wrote: PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND [ ... ] 32906 mysql 37 40 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

Re: mysql hiding from top

2009-04-27 Thread 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 SIZERES STATE C TIME WCPU COMMAND 88268 www

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
Hello, > 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 processe

Re: mysql hiding from top

2009-04-27 Thread Chuck Swiger
Hi-- On Apr 27, 2009, at 9:49 AM, Zbigniew Szalbot wrote: 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 liv

mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
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 SIZERES STATE C TIME WCPU COMMAND 1612 root1 200 9212K 6716K pause 2 0:26 0.00% perl5.8.9 966 ww