MFC of ZFSv15

[Guido Falsi]

On Thu, Sep 16, 2010 at 10:53:02AM +0100, Marian Hettwer wrote:
> On Thu, 16 Sep 2010 10:42:40 +0200, Guido Falsi <mad at madpilot.net>
> wrote:
> > On Thu, Sep 16, 2010 at 07:44:31AM +0200, Martin Matuska wrote:
> >> I have fixed the missing bits in r212688.
> >>
> >> Thanks for the notice.
> > 
> > Just a thank you message for the v15 development, MFS and this fast
> > fix. Maybe this is just noise on the lists, but I think that too
> > little thanks get to the FreeBSD developers, so a little noise like
> > this may be beneficial.
> 
> Agreed to that! Thanks for all the efforts in bringing ZFS to FreeBSD.
> I'm running 8.1-Release with v15 without any problems.
> 
> I just copied a 21GB MySQL datadir from a linux box to my FreeBSD/zfs
> workstation. Thanks to zfs compression the 21GB only consume 10GB on
> zfs.
> That's massive compression :-)

Related to this, I have a question.

Is it convenient to put databases on a compresed filesystem? Apart from
the space advantage, does it give any speed advantage/penalty?

Anyone has some benchmark or objective data about this?

Also are we talking about MyISAM or InnoDB tables? Or a mix of those?

-- 
Guido Falsi <mad at madpilot.net>