From owner-freebsd-performance@FreeBSD.ORG  Thu Dec 22 21:04:59 2005
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 7A2BB16A422
	for <freebsd-performance@freebsd.org>;
	Thu, 22 Dec 2005 21:04:59 +0000 (GMT)
	(envelope-from chrcoluk@gmail.com)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197])
	by mx1.FreeBSD.org (Postfix) with ESMTP id DFB9543D8F
	for <freebsd-performance@freebsd.org>;
	Thu, 22 Dec 2005 21:04:34 +0000 (GMT)
	(envelope-from chrcoluk@gmail.com)
Received: by wproxy.gmail.com with SMTP id i31so465956wra
	for <freebsd-performance@freebsd.org>;
	Thu, 22 Dec 2005 13:04:25 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=rELSyAud1V05masyoiGtvfhqmbjOuQ5JrhVZi2UcZz0Ino/0AeIYmq5sP1XgHcRHng3F/nJ3+uL8IvhLmezkhECMHPdNRrfPYqH/EeBh22LGIPXLYQ8cJUNkLuus9pyFoVy0lbcHnGF4HIRcpUMQrRK89upZ2G5u5fKC4je04RY=
Received: by 10.54.112.10 with SMTP id k10mr2736731wrc;
	Thu, 22 Dec 2005 13:04:25 -0800 (PST)
Received: by 10.54.123.20 with HTTP; Thu, 22 Dec 2005 13:04:25 -0800 (PST)
Message-ID: <3aaaa3a0512221304p3a35b1ecj@mail.gmail.com>
Date: Thu, 22 Dec 2005 21:04:25 +0000
From: Chris <chrcoluk@gmail.com>
To: Scott Long <scottl@samsco.org>
In-Reply-To: <43A35A1E.3020408@samsco.org>
MIME-Version: 1.0
References: <20051216064615.GA41775@gslin.org>
	<20051216070609.GA3216@il.fontys.nl>
	<20051216204322.GA66409@gslin.org> <43A35A1E.3020408@samsco.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Cc: freebsd-performance@freebsd.org, Gea-Suan Lin <gslin@gslin.org>,
	leo.huang.gd@gmail.com, Rink Springer <rink@il.fontys.nl>
Subject: Re: Benchmark MySQL Performance On FreeBSD And Linux
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 22 Dec 2005 21:04:59 -0000

On 17/12/05, Scott Long <scottl@samsco.org> wrote:
>
> Gea-Suan Lin wrote:
>
> > On Fri, Dec 16, 2005 at 08:06:09AM +0100, Rink Springer wrote:
> >
> >>>And you should disable these options, it may increase ~10% again:
> >>>
> >>>-cpu             I486_CPU
> >>>-cpu             I586_CPU
> >>> cpu             I686_CPU
> >>
> >>A recent discussion on -STABLE warned against removing I586_CPU, refer
> >>to
> >>
> http://lists.freebsd.org/pipermail/freebsd-stable/2005-December/020696.ht=
ml
> >>for more information.
> >
> >
> > Thanks, I'll try it later.
> >
> > BTW, did anyone try using jemalloc to test mysql ?
> >
>
> It was tried recently using supersmack and unix domain sockets.  The
> results were slightly slower (around 6%, IIRC).  The theory is that
> jemalloc doesn't pad out allocations as much, so there is high potential
> for cache line sharing (and thus cache thrash) between CPUs.
>
> Scott


Guys how do I know which threading library I am using, os is 5.4 STABLE and
I only enabled build_static options the rest is default, so which threading
library am I using.  If I am not using libthr how do I use that in 5.x
Thanks.

Chris