From owner-freebsd-hackers@FreeBSD.ORG  Tue Nov  9 21:14:01 2004
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
Delivered-To: freebsd-hackers@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 09D1316A4CE
	for <freebsd-hackers@freebsd.org>;
	Tue,  9 Nov 2004 21:14:01 +0000 (GMT)
Received: from suricate.otoh.org (suricate.otoh.org [64.81.247.155])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B85A543D4C
	for <freebsd-hackers@freebsd.org>;
	Tue,  9 Nov 2004 21:14:00 +0000 (GMT)
	(envelope-from freebsdhackers@otoh.org)
Received: from 64.81.247.155 (suricate.otoh.org [64.81.247.155])
	by suricate.otoh.org (Postfix) with SMTP id 9134D7DCFCE;
	Tue,  9 Nov 2004 13:13:59 -0800 (PST)
Received: by suricate.otoh.org (Postfix, from userid 1001)
	id B78377DCDF4; Tue,  9 Nov 2004 13:13:58 -0800 (PST)
Date: Tue, 9 Nov 2004 13:13:58 -0800
From: Paul Armstrong <freebsdhackers@otoh.org>
To: jesk <jesk@killall.org>
Message-ID: <20041109211358.GE78631@suricate.otoh.org>
References: <1099935987.4899.1730.camel@work.gusalmighty.com>
	<200411081334.18009.jhb@FreeBSD.org>
	<1099940205.4899.1733.camel@work.gusalmighty.com>
	<20041108191351.370c2d5d.thib@mi.is>
	<B4CC5D73A1357576BB486258@jesk.int.de.clara.net>
	<Pine.OSX.4.61.0411091157420.587@oof.local>
	<001701c4c69e$1e81c510$45fea8c0@turbofresse>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <001701c4c69e$1e81c510$45fea8c0@turbofresse>
X-Spam-Checker-Version: SpamAssassin 2.64 (2004-01-11) on suricate.otoh.org
X-Spam-Level: 
X-Spam-Status: No, hits=0.0 required=5.5 tests=none autolearn=ham version=2.64
cc: freebsd-hackers@freebsd.org
Subject: Re: Mysql - Linuxthreads : Still needed?
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 09 Nov 2004 21:14:01 -0000

On Tue, Nov 09, 2004 at 09:53:08PM +0100, jesk wrote:
> > For those that like a link:
> >
> > http://marc.theaimsgroup.com/?l=freebsd-current&m=109842492327954&w=2
> >
> > On Tue, 9 Nov 2004, jesk wrote:
> >
> > >> It would be nice if you could post the resaults back to the list
> > >> so other do not have to go through these steps and maybe create
> > >> an interesting disccusion about the use of linuxthreads with
> > >> MySQL or the "new" threading lib in fbsd.
> > >>
> > >> I my self am about to embark on quest to upgrade my servers from
> > >> 4.10 to 5.3-RELEASE and resault from a test like this would be
> > >> greatly appriceated since then I (and propably many others) will
> > >> not have to duplicate the efforts.
> > >>
> > >> Anyways, I could always run some tests to for comparisment.
> > >
> > > I did a performance comparison with different threading methods.
> > > Look for MySQL Performance thread on current@
> > >
> >
> fbsd outperformed linux in the end of my tests. ;)
> dont forget to disable HTT, this will increase the performance of threading.

The thread mentions that "update query first then select query" is
faster on Linux. What did you need to change to fix that (or did one of
the updates on the way to STABLE fix it)?

Paul