----- Original Message -----
From: "Mark Felder"
On Wed, Jul 24, 2013, at 10:13, Steven Hartland wrote:
gmirror may be another alternative that may correctly work with TRIM.
For reference correctly setup MySQL performance on ZFS works well for
use. Of particular interest is some of our data is highly compressible
making ZFS compression of particular benefit for our work load.
There are known interactivity issues with ZFS compression, so keep that
in mind.
Some people have said that, we've never seen it here, quite the opposite
in fact.
Also, you will want to make sure MySQL is on its own zfs filesystem and
you may want to set primarycache=metadata so the database chooses what
to keep in memory, not the filesystem. I ran a decent sized Postgres
database of my own with compression and it was OK, but I didn't hit it
very hard.
Depends on the setup, workload and available memory tbh I would use that
as a hard and fast rule.
Regards
Steve
================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.
In the event of misdirection, illegible or incomplete transmission please
telephone +44 845 868 1337
or return the E.mail to [email protected].
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-geom
To unsubscribe, send any mail to "[email protected]"
