From owner-freebsd-performance@FreeBSD.ORG  Fri Oct  6 04:48:27 2006
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from localhost.my.domain (localhost [127.0.0.1])
	by hub.freebsd.org (Postfix) with ESMTP id D64C516A407;
	Fri,  6 Oct 2006 04:48:26 +0000 (UTC)
	(envelope-from davidxu@freebsd.org)
From: David Xu <davidxu@freebsd.org>
To: freebsd-performance@freebsd.org
Date: Fri, 6 Oct 2006 12:48:22 +0800
User-Agent: KMail/1.8.2
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>
In-Reply-To: <2840.71.56.92.181.1160090644.squirrel@www.stelesys.com>
MIME-Version: 1.0
Content-Disposition: inline
Message-Id: <200610061248.22136.davidxu@freebsd.org>
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Cc: Jerry Bell <jbell@stelesys.com>
Subject: Re: Help with improving mysql performance on 6.2PRE
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 06 Oct 2006 04:48:27 -0000

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