From owner-freebsd-questions@FreeBSD.ORG  Sun May  3 15:20:31 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 65F63106564A
	for <freebsd-questions@freebsd.org>;
	Sun,  3 May 2009 15:20:31 +0000 (UTC) (envelope-from ws@au.dyndns.ws)
Received: from ipmail05.adl2.internode.on.net (ipmail05.adl2.internode.on.net
	[203.16.214.145])
	by mx1.freebsd.org (Postfix) with ESMTP id E00AE8FC13
	for <freebsd-questions@freebsd.org>;
	Sun,  3 May 2009 15:20:30 +0000 (UTC) (envelope-from ws@au.dyndns.ws)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AsECAOZM/UmWZWdv/2dsb2JhbAAIvgoHjU6DfQU
X-IronPort-AV: E=Sophos;i="4.40,286,1238941800"; d="scan'208";a="373302078"
Received: from ppp103-111.static.internode.on.net (HELO [192.168.1.144])
	([150.101.103.111])
	by ipmail05.adl2.internode.on.net with ESMTP; 04 May 2009 00:35:13 +0930
From: Wayne Sierke <ws@au.dyndns.ws>
To: Zbigniew Szalbot <z.szalbot@lcwords.com>
In-Reply-To: <dbdfb102e213cc2923eb75a56243dac7.squirrel@relay.lc-words.com>
References: <dbdfb102e213cc2923eb75a56243dac7.squirrel@relay.lc-words.com>
Content-Type: text/plain
Date: Mon, 04 May 2009 00:35:11 +0930
Message-Id: <1241363111.8180.21.camel@predator-ii.buffyverse>
Mime-Version: 1.0
X-Mailer: Evolution 2.26.1.1 FreeBSD GNOME Team Port 
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: mysql hiding from top
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 03 May 2009 15:20:31 -0000

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".