From owner-freebsd-database@FreeBSD.ORG  Fri Aug 19 15:59:20 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id F37BA16A41F;
	Fri, 19 Aug 2005 15:59:19 +0000 (GMT)
	(envelope-from nevans@talkpoint.com)
Received: from relay.talkpoint.com (pobox.talkpoint.com [204.141.15.158])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 527F543D46;
	Fri, 19 Aug 2005 15:59:18 +0000 (GMT)
	(envelope-from nevans@talkpoint.com)
Received: from ASSP-nospam ([127.0.0.1]) by relay.talkpoint.com with Microsoft
	SMTPSVC(5.0.2195.6713); Fri, 19 Aug 2005 11:59:18 -0400
Received: from 204.141.15.194 ([204.141.15.194] helo=pleiades.nextvenue.com)
	by ASSP-nospam ; 19 Aug 05 15:59:17 -0000
Date: Fri, 19 Aug 2005 11:59:17 -0400
From: Nick Evans <nevans@talkpoint.com>
To: Dean Hamstead <dean@bong.com.au>
Message-ID: <20050819115917.7351eef0@pleiades.nextvenue.com>
In-Reply-To: <4305C9D0.60607@bong.com.au>
References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> <4305C9D0.60607@bong.com.au>
X-Mailer: Sylpheed-Claws 1.9.11 (GTK+ 2.6.7; i386-portbld-freebsd5.4)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 19 Aug 2005 15:59:18.0074 (UTC)
	FILETIME=[F46E19A0:01C5A4D6]
Cc: freebsd-database@freebsd.org, Uzi <uzi@bmby.com>,
	freebsd-hardware@freebsd.org
Subject: Re: FreeBSD hardware solution for a database server
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 19 Aug 2005 15:59:20 -0000

On Fri, 19 Aug 2005 22:00:16 +1000
Dean Hamstead <dean@bong.com.au> wrote:

<snip>

> if your really dying for performace, go back to the ports tree
> and try compiling for better performance. ie mysql can compile
> static for (what it claims) better performance, and  there is
> one other option that eludes me. im not sure if linuxthreads
> is faster than native threads
> 
> you may also find mysql5 to be faster than 41 (assuming mysql)
> 
> 
> 
> Dean
> 

Linking/libmapping mysql against libthr gave a big performance boost on
RELENG_6 on our dual Opteron test server. Certainly much more than the compile
time options. It's been stable too and we beat the hell out of it.

sledgehammer# more /etc/libmap.conf 
[/usr/local/libexec/mysqld]
libpthread.so.2         libthr.so.2
libpthread.so.1         libthr.so.1
libpthread.so           libthr.so


Nick