From owner-freebsd-questions@FreeBSD.ORG  Sat Jan 28 13:03:33 2006
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 [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6C63A16A420
	for <freebsd-questions@freebsd.org>;
	Sat, 28 Jan 2006 13:03:33 +0000 (GMT)
	(envelope-from chrcoluk@gmail.com)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E1BC543D45
	for <freebsd-questions@freebsd.org>;
	Sat, 28 Jan 2006 13:03:32 +0000 (GMT)
	(envelope-from chrcoluk@gmail.com)
Received: by wproxy.gmail.com with SMTP id i31so743877wra
	for <freebsd-questions@freebsd.org>;
	Sat, 28 Jan 2006 05:03:31 -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=K8e+Yced9fXxwSPsFbNpuUc9z8us4YdHJNrl9bb1u9PEkLkXXjPEbOndfJXcvtiOMZp8lUQDqgvNqkSis3HIs5F4hEEG8wZUIw/+C5VnnhBAHN16Zbqxe6jgDUhsmBflG+jbejJlYq0iYXII15Q8Ms6KgPsdS8Tlmh5OjQaFBvw=
Received: by 10.54.114.1 with SMTP id m1mr5135597wrc;
	Sat, 28 Jan 2006 05:03:31 -0800 (PST)
Received: by 10.54.122.17 with HTTP; Sat, 28 Jan 2006 05:03:31 -0800 (PST)
Message-ID: <3aaaa3a0601280503t2dc3e92ej@mail.gmail.com>
Date: Sat, 28 Jan 2006 13:03:31 +0000
From: Chris <chrcoluk@gmail.com>
To: Kris Kennaway <kris@obsecurity.org>
In-Reply-To: <20060127202202.GA65737@xor.obsecurity.org>
MIME-Version: 1.0
References: <DD408EDB-CC70-47BC-A8A9-3B0CE21596AD@gmail.com>
	<20060127202202.GA65737@xor.obsecurity.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: Romeo Theriault <romeotheriault@gmail.com>, freebsd-questions@freebsd.org
Subject: Re: mysql - linuxthreads
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: Sat, 28 Jan 2006 13:03:33 -0000

On 27/01/06, Kris Kennaway <kris@obsecurity.org> wrote:
>
> On Fri, Jan 27, 2006 at 03:15:05PM -0500, Romeo Theriault wrote:
> > A week or so ago I wrote to the this list asking about Freebsd and
> > Mysql, wondering if you still needed to compile Mysql with
> > linuxthreads to get better performance under Freebsd 6. I didn't get
> > much of a response so I looked around for the answer. I thought I'd
> > write back to the mailing list to tell anyone interested what I found.
>
> Thanks, this is always useful!
>
> > In the Freebsd 6.0 is seems that to get the best MySQL performance
> > you need to do a few things.
> >       #compile your kernel with the ULE scheduler
>
> I'd be inclined to doubt this..all my measurements show ULE is slower
> than 4BSD except at negligible load.  How did you measure it?
>
> >       #use the TSC timecounter
> >       #use the libthr threading library with mysql
>
> You definitely want libthr.
>
> Kris
>
>
>
is there large differences between libthr on 6.x and 5.x, I mean is libthr
the best option for 5.x also?

Chris