From owner-freebsd-fs@FreeBSD.ORG Fri Nov 16 15:48:51 2007 Return-Path: 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 A8F2516A420 for ; Fri, 16 Nov 2007 15:48:51 +0000 (UTC) (envelope-from alexander@leidinger.net) Received: from redbull.bpaserver.net (redbullneu.bpaserver.net [213.198.78.217]) by mx1.freebsd.org (Postfix) with ESMTP id 0FE3813C478 for ; Fri, 16 Nov 2007 15:48:50 +0000 (UTC) (envelope-from alexander@leidinger.net) Received: from outgoing.leidinger.net (p54A5759A.dip.t-dialin.net [84.165.117.154]) by redbull.bpaserver.net (Postfix) with ESMTP id 6BF402E334; Fri, 16 Nov 2007 16:31:18 +0100 (CET) Received: from webmail.leidinger.net (webmail.Leidinger.net [192.168.1.102]) by outgoing.leidinger.net (Postfix) with ESMTP id BA672670D1; Fri, 16 Nov 2007 16:31:15 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=Leidinger.net; s=outgoing-alex; t=1195227075; bh=PFUzAHWh9LcSKgNG1owTk7JOyIVUitr5Y ZjNbDhHxTA=; h=Message-ID:X-Priority:Date:From:To:Cc:Subject: References:In-Reply-To:MIME-Version:Content-Type: Content-Disposition:Content-Transfer-Encoding:User-Agent; b=TcuWFm 6Qxh63Tq2+GR0h2cHD1zeyf7DRiH387g5GFaPOCZlUceohscSoG7hRyqnaww70b91h1 n2UCWQIFdfGKJ3Yo/0w9ZoeWhtXGZ3AqqB/3OE4w3obKdr9v7DBn1iwknXV6bxeppC7 mQ2JXtejW8Kv2IOOhpqyl01cKr5kVY1pmChTurR3Xf8OOG5x8r8UAe6IvhWHtebgK9e +/O7Eu+AyKDTuCuYduQckmMHE7Qi6n4IsvJMJn2T4VKE7rDY2PJUCszhEpPeXxNxd3V fxUwNWSv1uqfCenQ+m3wMQn080Io/ykYAX8X3PFObXZVT9UzqMnfjUsAls/MbUnIF1f g== Received: (from www@localhost) by webmail.leidinger.net (8.14.1/8.13.8/Submit) id lAGFVFng072095; Fri, 16 Nov 2007 16:31:15 +0100 (CET) (envelope-from Alexander@Leidinger.net) Received: from pslux.cec.eu.int (pslux.cec.eu.int [158.169.9.14]) by webmail.leidinger.net (Horde MIME library) with HTTP; Fri, 16 Nov 2007 16:31:15 +0100 Message-ID: <20071116163115.oavrcgayo0wg8sc8@webmail.leidinger.net> X-Priority: 3 (Normal) Date: Fri, 16 Nov 2007 16:31:15 +0100 From: Alexander Leidinger To: Peter Schuller References: <200711160136.56551.peter.schuller@infidyne.com> In-Reply-To: <200711160136.56551.peter.schuller@infidyne.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Internet Messaging Program (IMP) H3 (4.1.4) / FreeBSD-7.0 X-BPAnet-MailScanner-Information: Please contact the ISP for more information X-BPAnet-MailScanner: Found to be clean X-BPAnet-MailScanner-SpamCheck: not spam, SpamAssassin (not cached, score=-13.927, required 8, BAYES_00 -15.00, DKIM_SIGNED 0.00, DKIM_VERIFIED -0.00, MIME_QP_LONG_LINE 1.40, RDNS_DYNAMIC 0.10, SMILEY -0.50, TW_ZF 0.08) X-BPAnet-MailScanner-From: alexander@leidinger.net X-Spam-Status: No Cc: freebsd-fs@freebsd.org, freebsd-current@freebsd.org, Ivan Voras Subject: Re: ZFS & MySQL X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Nov 2007 15:48:51 -0000 Quoting Peter Schuller (from Fri, 16 Nov =20 2007 01:36:47 +0100): >> 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 > CURRENT). It was in uninterruptable sleep, but I can't swear to whether it > 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 > sounds like that won't be more useful than what you already have available= . If you really do benchmarks and not failure verification, you should =20 take care about the recordsize attribute in the corresponding ZFS, =20 else you may get suboptimal performance (this is a suggestion of SUN =20 for the use of ZFS with DBs, personally I don't have access to a =20 machine where the DB is used enough that we could notice a performance =20 difference). Bye, Alexander. --=20 The most disagreeable thing that your worst enemy says to your face does not approach what your best friends say behind your back. =09=09-- Alfred De Musset http://www.Leidinger.net Alexander @ Leidinger.net: PGP ID =3D B0063FE7 http://www.FreeBSD.org netchild @ FreeBSD.org : PGP ID =3D 72077137