From owner-freebsd-current@FreeBSD.ORG Fri Nov 16 15:47:48 2007 Return-Path: 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 27EA916A468; Fri, 16 Nov 2007 15:47:48 +0000 (UTC) (envelope-from doug@polands.org) Received: from ms-smtp-02.rdc-kc.rr.com (ms-smtp-02.rdc-kc.rr.com [24.94.166.122]) by mx1.freebsd.org (Postfix) with ESMTP id B175D13C45A; Fri, 16 Nov 2007 15:47:47 +0000 (UTC) (envelope-from doug@polands.org) Received: from corinth.polands.org (CPE-75-87-219-217.new.res.rr.com [75.87.219.217]) by ms-smtp-02.rdc-kc.rr.com (8.13.6/8.13.6) with ESMTP id lAGFdpk4018221; Fri, 16 Nov 2007 09:39:52 -0600 (CST) Received: from email.polands.org (ammon.polands.org [172.16.1.7]) by corinth.polands.org (8.13.8/8.13.8) with ESMTP id lAGFlX7Z065541; Fri, 16 Nov 2007 09:47:33 -0600 (CST) (envelope-from doug@polands.org) Received: from 172.16.1.7 (proxying for 172.16.1.46) (SquirrelMail authenticated user djp) by email.polands.org with HTTP; Fri, 16 Nov 2007 09:47:33 -0600 (CST) Message-ID: <63176.172.16.1.7.1195228053.squirrel@email.polands.org> In-Reply-To: <20071116163115.oavrcgayo0wg8sc8@webmail.leidinger.net> References: <200711160136.56551.peter.schuller@infidyne.com> <20071116163115.oavrcgayo0wg8sc8@webmail.leidinger.net> Date: Fri, 16 Nov 2007 09:47:33 -0600 (CST) From: "Doug Poland" To: "Alexander Leidinger" User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: ClamAV 0.88.4/4810/Fri Nov 16 02:38:11 2007 on corinth.polands.org X-Virus-Status: Clean Cc: freebsd-fs@freebsd.org, freebsd-current@freebsd.org, Peter Schuller , Ivan Voras 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Nov 2007 15:47:48 -0000 On Fri, November 16, 2007 09:31, Alexander Leidinger wrote: > Quoting Peter Schuller (from Fri, 16 > Nov 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 > take care about the recordsize attribute in the corresponding ZFS, > else you may get suboptimal performance (this is a suggestion of SUN > for the use of ZFS with DBs, personally I don't have access to a > machine where the DB is used enough that we could notice a > performance difference). > Might be a good place to start: http://dev.mysql.com/tech-resources/articles/mysql-zfs.html -- Regards, Doug