From owner-freebsd-questions@FreeBSD.ORG  Fri May 11 09:27:59 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 0159916A402
	for <freebsd-questions@freebsd.org>;
	Fri, 11 May 2007 09:27:59 +0000 (UTC)
	(envelope-from almarrie@gmail.com)
Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.247])
	by mx1.freebsd.org (Postfix) with ESMTP id B576513C487
	for <freebsd-questions@freebsd.org>;
	Fri, 11 May 2007 09:27:58 +0000 (UTC)
	(envelope-from almarrie@gmail.com)
Received: by an-out-0708.google.com with SMTP id d23so211703and
	for <freebsd-questions@freebsd.org>;
	Fri, 11 May 2007 02:27:58 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=iD9E2PwVKbSeL1CRbBazgHWMU0kbYw8jqGpy7tNWMyhSgTh3fdL78Z8LrKJssimJmA8hubCl6Zc9YcQ/58FEUGCQKbWCsAYCLq1Se0lhSzLg1Ykzp8bSD2CsqcctJER1I6gPAu2vq5/kP/Jo2xO42cJTMdu7Uis4iRUodhBbaOU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=S8p2nA+LF3/Aa1Zi8MzJFmrIrL0vOJbFnNJr0cTxQ0/X2AOaxG5f3Ttvn7o2/yUdbOAVxwuWIpCzspOelx3JBj75Zii0ttCrjQPEZUN7Y77z4+1SntWn40YNTwwUZIUo16QWkNCvuaJ+7IjzLavExa0+FECAqQnOZPhJAesBerU=
Received: by 10.100.121.12 with SMTP id t12mr1006875anc.1178875677920;
	Fri, 11 May 2007 02:27:57 -0700 (PDT)
Received: by 10.100.9.14 with HTTP; Fri, 11 May 2007 02:27:57 -0700 (PDT)
Message-ID: <499c70c0705110227p2bf1c0b2y1650b7ce9ecb44fd@mail.gmail.com>
Date: Fri, 11 May 2007 12:27:57 +0300
From: "Abdullah Ibn Hamad Al-Marri" <almarrie@gmail.com>
To: "Martin Blapp" <mb@imp.ch>
In-Reply-To: <20070511112011.U2786@godot>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com>
	<20070511105652.S2786@godot>
	<499c70c0705110212h400d2466wdf4d2fce6ef41884@mail.gmail.com>
	<20070511112011.U2786@godot>
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: MySQL slowness in SMP
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: Fri, 11 May 2007 09:27:59 -0000

On 5/11/07, Martin Blapp <mb@imp.ch> wrote:
>
> Hi,
>
> Ohh, I overread that you already use libthr.
>
> But ...
>
> > 90293 mysql        19 100    0   434M   187M ucond  1 176.6H 95.95% mysqld
>
> It looks like you did not turn on 'showing threads' in top, else you would
> have seen that many mysqld's are running on cpu 0, other on cpu 1.
>
> --
> Martin

So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster
or it's not optimized for dual cpu yet?

-- 
Regards,

-Abdullah Ibn Hamad Al-Marri
Arab Portal
http://www.WeArab.Net/