Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 19 Aug 2005 11:59:17 -0400
From:      Nick Evans <nevans@talkpoint.com>
To:        Dean Hamstead <dean@bong.com.au>
Cc:        freebsd-database@freebsd.org, Uzi <uzi@bmby.com>, freebsd-hardware@freebsd.org
Subject:   Re: FreeBSD hardware solution for a database server
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>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050819115917.7351eef0>