From owner-freebsd-geom@FreeBSD.ORG  Wed Jul 24 15:27:39 2013
Return-Path: <owner-freebsd-geom@FreeBSD.ORG>
Delivered-To: freebsd-geom@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTP id 16C657E1
 for <freebsd-geom@freebsd.org>; Wed, 24 Jul 2013 15:27:39 +0000 (UTC)
 (envelope-from feld@freebsd.org)
Received: from out1-smtp.messagingengine.com (out1-smtp.messagingengine.com
 [66.111.4.25])
 (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by mx1.freebsd.org (Postfix) with ESMTPS id DD4C428FC
 for <freebsd-geom@freebsd.org>; Wed, 24 Jul 2013 15:27:38 +0000 (UTC)
Received: from compute3.internal (compute3.nyi.mail.srv.osa [10.202.2.43])
 by gateway1.nyi.mail.srv.osa (Postfix) with ESMTP id B783521564
 for <freebsd-geom@freebsd.org>; Wed, 24 Jul 2013 11:27:35 -0400 (EDT)
Received: from web3 ([10.202.2.213])
 by compute3.internal (MEProxy); Wed, 24 Jul 2013 11:27:36 -0400
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=
 messagingengine.com; h=message-id:from:to:mime-version
 :content-transfer-encoding:content-type:in-reply-to:references
 :subject:date; s=smtpout; bh=glDZbMzuv4c9ZkabJFhlEkH7guk=; b=orK
 CvXGvYkyH4PsAoX4C3m6ibszf1SliqSPJtpXIviJakcCIv39yOuMZg24XlooAObE
 wAUcwVO+dgSRsgLUfpoLQ/pv8/dslchKhc/sfjG2sebopivHz+cvEPPDSXGbtQ/R
 JStsIx7UkK9raFCKztr7IZurE7al0rn//eB7AVsc=
Received: by web3.nyi.mail.srv.osa (Postfix, from userid 99)
 id C2F9BB01C74; Wed, 24 Jul 2013 11:27:35 -0400 (EDT)
Message-Id: <1374679655.8934.9223372036856590361.535ACEE3@webmail.messagingengine.com>
X-Sasl-Enc: OOnW9vYZ60X81MEMO0OGqjXzLi/Qw29lgCqRCeuTK528 1374679655
From: Mark Felder <feld@freebsd.org>
To: freebsd-geom@freebsd.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
X-Mailer: MessagingEngine.com Webmail Interface - ajax-7c8d3e73
In-Reply-To: <BDD072A6EA1C4AE4A7E590BB094F7C87@multiplay.co.uk>
References: <512DC7C043034F891F1012DA@Mail-PC.tdx.co.uk>
 <A34136B4528A476BB11F178D9469D7EB@multiplay.co.uk>
 <D6B2C9B94A5FD0E3111D83F7@Mail-PC.tdx.co.uk>
 <066EB1F973D44AAC951D4D47C577266F@multiplay.co.uk>
 <43FCB2933BDA7D36CA1719CD@Mail-PC.tdx.co.uk>
 <BDD072A6EA1C4AE4A7E590BB094F7C87@multiplay.co.uk>
Subject: Re: TRIM or no TRIM?
Date: Wed, 24 Jul 2013 10:27:35 -0500
X-BeenThere: freebsd-geom@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: GEOM-specific discussions and implementations
 <freebsd-geom.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-geom>,
 <mailto:freebsd-geom-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-geom>
List-Post: <mailto:freebsd-geom@freebsd.org>
List-Help: <mailto:freebsd-geom-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-geom>,
 <mailto:freebsd-geom-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 24 Jul 2013 15:27:39 -0000

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.

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.