MFC of ZFSv15

Ivan Voras ivoras at
Thu Sep 16 11:04:58 UTC 2010

On 09/16/10 12:42, Guido Falsi wrote:

> 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?

It depends on what you do. It will not save you memory usage either 
since data needs to be decompressed when read.

If the database is lightly loaded I don't think there will ever be 
problems. Also if the database is mostly read-only. If it's used in a 
heavy loaded read+write environment or if it is CPU-bound, it is 
probably a bad idea to put it on a compressed file system.

> Anyone has some benchmark or objective data about this?

I know about this one:

But it only really measures copy (cp) speeds and compression, not 
database performance.

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

MyISAM would probably be faster to compress and manage :)

More information about the freebsd-stable mailing list