From owner-freebsd-fs@FreeBSD.ORG  Thu Nov 15 13:23:20 2007
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 8118616A420
	for <freebsd-fs@freebsd.org>; Thu, 15 Nov 2007 13:23:20 +0000 (UTC)
	(envelope-from freebsd-fs@m.gmane.org)
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by mx1.freebsd.org (Postfix) with ESMTP id 3D17C13C50E
	for <freebsd-fs@freebsd.org>; Thu, 15 Nov 2007 13:23:20 +0000 (UTC)
	(envelope-from freebsd-fs@m.gmane.org)
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1IsegY-0004g8-8t
	for freebsd-fs@freebsd.org; Thu, 15 Nov 2007 13:23:10 +0000
Received: from lara.cc.fer.hr ([161.53.72.113])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <freebsd-fs@freebsd.org>; Thu, 15 Nov 2007 13:23:10 +0000
Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <freebsd-fs@freebsd.org>; Thu, 15 Nov 2007 13:23:10 +0000
X-Injected-Via-Gmane: http://gmane.org/
To: freebsd-fs@freebsd.org
From: Ivan Voras <ivoras@freebsd.org>
Date: Thu, 15 Nov 2007 14:26:41 +0100
Lines: 12
Message-ID: <fhhh7o$1s5$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr
User-Agent: Thunderbird 2.0.0.6 (X11/20070801)
Sender: news <news@ger.gmane.org>
Cc: freebsd-current@freebsd.org
Subject: ZFS & MySQL
X-BeenThere: freebsd-fs@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Filesystems <freebsd-fs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-fs>
List-Post: <mailto:freebsd-fs@freebsd.org>
List-Help: <mailto:freebsd-fs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 15 Nov 2007 13:23:20 -0000

Hi,

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 think a (possibly long-ish) stress test on a multi-CPU machine (my own
is only dual, but has a relatively big uptime) with both reading and
writing via mysqld might ferret out a problem with concurrency.