Date: Fri, 6 Oct 2006 12:48:22 +0800 From: David Xu <davidxu@freebsd.org> To: freebsd-performance@freebsd.org Cc: Jerry Bell <jbell@stelesys.com> Subject: Re: Help with improving mysql performance on 6.2PRE Message-ID: <200610061248.22136.davidxu@freebsd.org> In-Reply-To: <2840.71.56.92.181.1160090644.squirrel@www.stelesys.com> References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> <45255A36.5010108@quip.cz> <2840.71.56.92.181.1160090644.squirrel@www.stelesys.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Friday 06 October 2006 07:24, Jerry Bell wrote: > I always thougt that compiling something static increased performance, but > then that's probably true for things that have to startup and shutdown > frequently. > > Thanks again. > > Jerry > static compiling will link libpthread but not libthr. I found setting larger buffer in /etc/my.cnf will yield much better result than default configuration, also turnning off log-bin option makes a different on my machine. mysql 5.x is much better than 4.1 on select benchmark, almost extra 25% performance improvement I can get on athlon64 X2 3800+ running in 64-bit mode. David Xu
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200610061248.22136.davidxu>