From owner-freebsd-questions@FreeBSD.ORG  Tue Feb 13 10:18:33 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 C9CCF16A407
	for <freebsd-questions@freebsd.org>;
	Tue, 13 Feb 2007 10:18:33 +0000 (UTC)
	(envelope-from almarrie@gmail.com)
Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.237])
	by mx1.freebsd.org (Postfix) with ESMTP id 8B0D013C4BF
	for <freebsd-questions@freebsd.org>;
	Tue, 13 Feb 2007 10:18:33 +0000 (UTC)
	(envelope-from almarrie@gmail.com)
Received: by wr-out-0506.google.com with SMTP id 69so2270887wra
	for <freebsd-questions@freebsd.org>;
	Tue, 13 Feb 2007 02:18:33 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=HWX84UgHIvcmaQV9uA9b213ekL3SaWgLG/CuTDj/otYw8vwDVMQDHz/LItObxtsB1K0Q/WLC4+sONs2ACIDY7IohQgTNl1KmUVrAhPijU/CdpnSvId2gDDTdMcL/CzDE6BLwUVZYvXI0BkzTmPjmchiQ0hrrnYdFQ5kAYKz4J+E=
Received: by 10.114.47.1 with SMTP id u1mr6786087wau.1171361912644;
	Tue, 13 Feb 2007 02:18:32 -0800 (PST)
Received: by 10.115.91.7 with HTTP; Tue, 13 Feb 2007 02:18:32 -0800 (PST)
Message-ID: <499c70c0702130218n211912bdq9236b9fe53197b86@mail.gmail.com>
Date: Tue, 13 Feb 2007 13:18:32 +0300
From: "Abdullah Ibn Hamad Al-Marri" <almarrie@gmail.com>
To: "Frank Altpeter" <frank@altpeter.de>, freebsd-questions@freebsd.org
In-Reply-To: <20070213085839.GA61365@corpex.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20070213085839.GA61365@corpex.de>
Cc: 
Subject: Re: SMP system threading performance question
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: Tue, 13 Feb 2007 10:18:33 -0000

On 2/13/07, Frank Altpeter <frank@altpeter.de> wrote:

<snip>
> The problem is quite disturbing, since that machine hosts a mysql database
> which is performing low because half of the cpu power is not used at all.
> I recompiled it with WITH_PROC_SCOPE_PTH=YES and with
> WITH_LINUXTHREADS=YES but both didn't help, so i assume some OS related
> reason for this to happen.
>
>
> Happy for any hints,
>
>
>         Frank Altpeter

You better use libthr with the MySQL instead of linuxthreads, and
don't use HTT with FreeBSD since it hurts the performance.

For more info about it check http://wiki.freebsd.org/MySQL

Also check how to use it with libmap.conf to make mysql uses libthr as well.

Good luck with it ;)

-- 
Regards,

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