From owner-freebsd-current@FreeBSD.ORG  Sat Oct 29 15:38:55 2005
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
X-Original-To: current@freebsd.org
Delivered-To: freebsd-current@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 712D016A41F
	for <current@freebsd.org>; Sat, 29 Oct 2005 15:38:55 +0000 (GMT)
	(envelope-from tom.hurst@clara.net)
Received: from spork.qfe3.net (spork.qfe3.net [212.13.207.101])
	by mx1.FreeBSD.org (Postfix) with ESMTP id CBA0743D49
	for <current@freebsd.org>; Sat, 29 Oct 2005 15:38:54 +0000 (GMT)
	(envelope-from tom.hurst@clara.net)
Received: from [81.104.55.176] (helo=voi.aagh.net)
	by spork.qfe3.net with esmtp (Exim 4.54 (FreeBSD))
	id 1EVsn4-000IPc-4M; Sat, 29 Oct 2005 16:38:42 +0100
Received: from freaky by voi.aagh.net with local (Exim 4.53 (FreeBSD))
	id 1EVsn3-0009j1-Mq; Sat, 29 Oct 2005 16:38:41 +0100
Date: Sat, 29 Oct 2005 16:38:41 +0100
From: Thomas Hurst <tom.hurst@clara.net>
To: Xin LI <delphij@frontfree.net>
Message-ID: <20051029153841.GA29342@voi.aagh.net>
Mail-Followup-To: Xin LI <delphij@frontfree.net>,
	Marian Hettwer <MH@kernel32.de>, current@freebsd.org
References: <435F48DA.6060009@kernel32.de> <1130320668.810.87.camel@spirit>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="AhhlLboLdkugWU4S"
Content-Disposition: inline
In-Reply-To: <1130320668.810.87.camel@spirit>
Organization: Not much.
User-Agent: Mutt/1.5.11
Sender: Thomas Hurst <freaky@voi.aagh.net>
X-RBL-Warning: 81.104.55.176 is in RBL blacklist at dnsbl.sorbs.net
Cc: current@freebsd.org, Marian Hettwer <MH@kernel32.de>
Subject: Re: MySQL Performance 6.0rc1
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>, 
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 29 Oct 2005 15:38:55 -0000


--AhhlLboLdkugWU4S
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Xin LI (delphij@frontfree.net) wrote:

> Some observations that I think can affect MySQL performance:
>  - Our malloc(3) implementation might be sub-optimal for the workload.

I've tried linking MySQL against some of the alternatives in ports.  I
must be missing something since I could never make it do more than start
up and lock up.

>  - Lack of some POSIX system call which was implemented in other ways
> (e.g. we do not have fsyncdata yet)
>  - Some detailed implementation difference between our and Linux's
> threading library, or MySQL itself.

Terry posted an interesting comment on /. giving some reasonable
sounding suggestions as to why MySQL's performance is so pessimised on
FreeBSD (and others):

 http://slashdot.org/comments.pl?sid=3D162629&tid=3D7&cid=3D13611424

--=20
Thomas 'Freaky' Hurst
    http://hur.st/

--AhhlLboLdkugWU4S
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (FreeBSD)

iD8DBQFDY5d/NBBHZ542MwQRArVzAKCKDF+7CW5jZVPuBFS0533P2S6nNACePn3h
jwkR9RV/doDfHDaGFjRyoNE=
=xlY7
-----END PGP SIGNATURE-----

--AhhlLboLdkugWU4S--