From owner-freebsd-questions@FreeBSD.ORG Mon Apr 27 17:39:58 2009 Return-Path: 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 724181065690 for ; Mon, 27 Apr 2009 17:39:58 +0000 (UTC) (envelope-from prvs=361c1ced8=pschmehl_lists@tx.rr.com) Received: from ip-relay-001.utdallas.edu (ip-relay-001.utdallas.edu [129.110.20.111]) by mx1.freebsd.org (Postfix) with ESMTP id 3F03A8FC14 for ; Mon, 27 Apr 2009 17:39:58 +0000 (UTC) (envelope-from prvs=361c1ced8=pschmehl_lists@tx.rr.com) X-Group: RELAYLIST X-IronPort-AV: E=Sophos;i="4.40,255,1238994000"; d="scan'208";a="10958002" Received: from smtp3.utdallas.edu ([129.110.20.110]) by ip-relay-001.utdallas.edu with ESMTP; 27 Apr 2009 12:11:11 -0500 Received: from utd65257.utdallas.edu (utd65257.utdallas.edu [129.110.3.28]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp3.utdallas.edu (Postfix) with ESMTPSA id 31E8288AE; Mon, 27 Apr 2009 12:11:11 -0500 (CDT) Date: Mon, 27 Apr 2009 17:11:11 +0000 From: Paul Schmehl To: Zbigniew Szalbot , freebsd-questions@freebsd.org Message-ID: <720E9A87F95E44B452BF93E9@utd65257.utdallas.edu> In-Reply-To: References: X-Mailer: Mulberry/4.0.6 (Linux/x86) X-Munged-Reply-To: Figure it out MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: Subject: Re: mysql hiding from top X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Paul Schmehl List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Apr 2009 17:39:58 -0000 --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 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.