From owner-freebsd-performance@FreeBSD.ORG  Wed Apr  5 05:31:39 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 C57CC16A400
	for <freebsd-performance@freebsd.org>;
	Wed,  5 Apr 2006 05:31:38 +0000 (UTC)
	(envelope-from yfxu@corp.netease.com)
From: David Xu <yfxu@corp.netease.com>
Organization: netease.com
To: freebsd-performance@freebsd.org
Date: Wed, 5 Apr 2006 13:31:23 +0800
User-Agent: KMail/1.8.2
References: <200604041942.18767.hadara@bsd.ee>
In-Reply-To: <200604041942.18767.hadara@bsd.ee>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="gb2312"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200604051331.23826.yfxu@corp.netease.com>
X-Mailman-Approved-At: Wed, 05 Apr 2006 12:34:10 +0000
Subject: Re: mysql performance on 4 * dualcore opteron
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: Wed, 05 Apr 2006 05:31:39 -0000

=D4=DA Wednesday 05 April 2006 00:42=A3=ACSven Petai =D0=B4=B5=C0=A3=BA
>=20
> hi
>=20
> Before I begin, let me just say that I'm probably aware most of the threa=
ds=20
> about mysql performance in various fbsd lists over last couple of years, =
so=20
> please let's not consentrate on the usual points made over and over again=
=20
> like how filesystems are mounted under linux, how fast time() is or how=20
> various combinations of scheduler/threding library/compiler flags give yo=
u=20
> ~5-10% better performance. It's very unlikely that any of these reasons, =
or=20
> even all of them together can explain performance differences of 2-3 *=20
>=20
Can you disable log-bin option in my.cnf to see if it is  a FS bottleneck
when you are running update-smack ? please run Linux and FreeBSD
with same hardware and my.cnf configuration, thanks.
I know this is not very right, but it can be used to narrow down some
kernel performance problem.

Regards,
David Xu