Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 16 Nov 2007 09:47:33 -0600 (CST)
From:      "Doug Poland" <doug@polands.org>
To:        "Alexander Leidinger" <Alexander@Leidinger.net>
Cc:        freebsd-fs@freebsd.org, freebsd-current@freebsd.org, Ivan Voras <ivoras@freebsd.org>
Subject:   Re: ZFS & MySQL
Message-ID:  <63176.172.16.1.7.1195228053.squirrel@email.polands.org>
In-Reply-To: <20071116163115.oavrcgayo0wg8sc8@webmail.leidinger.net>
References:  <fhhh7o$1s5$1@ger.gmane.org> <200711160136.56551.peter.schuller@infidyne.com> <20071116163115.oavrcgayo0wg8sc8@webmail.leidinger.net>

next in thread | previous in thread | raw e-mail | index | archive | help

On Fri, November 16, 2007 09:31, Alexander Leidinger wrote:
> Quoting Peter Schuller <peter.schuller@infidyne.com> (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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?63176.172.16.1.7.1195228053.squirrel>