From owner-freebsd-current@FreeBSD.ORG  Fri Nov 16 00:36:19 2007
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
Delivered-To: freebsd-current@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id CEF7C16A41A
	for <freebsd-current@freebsd.org>; Fri, 16 Nov 2007 00:36:19 +0000 (UTC)
	(envelope-from peter.schuller@infidyne.com)
Received: from smtp.infidyne.com (ds9.infidyne.com [88.80.6.206])
	by mx1.freebsd.org (Postfix) with ESMTP id 895C513C43E
	for <freebsd-current@freebsd.org>; Fri, 16 Nov 2007 00:35:27 +0000 (UTC)
	(envelope-from peter.schuller@infidyne.com)
Received: from c-5416e555.03-51-73746f3.cust.bredbandsbolaget.se
	(c-5416e555.03-51-73746f3.cust.bredbandsbolaget.se [85.229.22.84])
	by smtp.infidyne.com (Postfix) with ESMTP id 37765729F5;
	Fri, 16 Nov 2007 01:35:13 +0100 (CET)
From: Peter Schuller <peter.schuller@infidyne.com>
To: freebsd-fs@freebsd.org
Date: Fri, 16 Nov 2007 01:36:47 +0100
User-Agent: KMail/1.9.7
References: <fhhh7o$1s5$1@ger.gmane.org>
In-Reply-To: <fhhh7o$1s5$1@ger.gmane.org>
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="nextPart2135690.ajQ7k9PUjr";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200711160136.56551.peter.schuller@infidyne.com>
Cc: freebsd-current@freebsd.org, Ivan Voras <ivoras@freebsd.org>
Subject: Re: ZFS & MySQL
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: Fri, 16 Nov 2007 00:36:19 -0000

--nextPart2135690.ajQ7k9PUjr
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

> Can somebody who has done MySQL benchmarks (e.g. Kris Kennaway, but I
> don't want to point fingers :) ) try them when MySQL is hosted on ZFS?
> I'm currently having a problem where mysqld gets stuck in "zfs" state
> and it becomes completely unusable and unkillable. The machine generally
> works, but cannot be rebooted from the OS in this case (it must be
> manually power-cycled).

I had an unkillable MySQLd a while ago that required reboot (pre-RELENG_7=20
CURRENT). It was in uninterruptable sleep, but I can't swear to whether it=
=20
was in zfs state. This was on a quadcore core 2 duo.

I can do some sysbenching on a dual core machine with and without ZFS, but =
it=20
sounds like that won't be more useful than what you already have available.

=2D-=20
/ Peter Schuller

PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org


--nextPart2135690.ajQ7k9PUjr
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQBHPOYoDNor2+l1i30RAqFzAJ0afi6fO90DZEzMFzWmFs7h50wg4QCg07zG
RAU4pSL3L9RzLlXxRTYe3eA=
=agiI
-----END PGP SIGNATURE-----

--nextPart2135690.ajQ7k9PUjr--