From owner-freebsd-smp@FreeBSD.ORG Wed Jul 28 14:35:32 2004 Return-Path: Delivered-To: freebsd-smp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4B05F16A4CE for ; Wed, 28 Jul 2004 14:35:32 +0000 (GMT) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id D90B243D69 for ; Wed, 28 Jul 2004 14:35:31 +0000 (GMT) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.12.10/8.12.10) id i6SEZVXv069191; Wed, 28 Jul 2004 09:35:31 -0500 (CDT) (envelope-from dan) Date: Wed, 28 Jul 2004 09:35:31 -0500 From: Dan Nelson To: Radoslav Vasilev Message-ID: <20040728143530.GC9972@dan.emsphone.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: FreeBSD 5.2-CURRENT X-message-flag: Outlook Error User-Agent: Mutt/1.5.6i cc: freebsd-smp@freebsd.org Subject: Re: FreeBSD SMP on 4.x + usage monitoring X-BeenThere: freebsd-smp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: FreeBSD SMP implementation group List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Jul 2004 14:35:32 -0000 In the last episode (Jul 28), Radoslav Vasilev said: > Very important to me is are we able to monitor or, at a minum, to be sure, > thread-enabled application is using more than just a single CPU. For > example: > > 1) I compiled linuxthreads from ports direcotory. > 2) I compiled Mysql 4.0.18 Server, with linuxthreads , again from ports collection > 3) SMP enabled kernel > > What I observe, with ``top -I`` is mysqld using just one CPU, during a > single bulky, SQL query. That's expected behaviour. MySQL cannot parallelize a single query to balance load across CPUs and get faster I/O the way Oracle does. "ps ax | grep mysql" should still show a couple other idle processes (the LinuxThreads support ones, plus any other client sessions you have open to mysql). > My questions are: > 1) Is top the proper way of cpu usage monitoring > 2) are there any other tool for real time monitoring for SMP "systat -v" is also a good one, which shows you disk throughput and %busy stats along with a bunch of other info. -- Dan Nelson dnelson@allantgroup.com