From nobody Mon Jul 5 15:29:00 2021 X-Original-To: freebsd-stable@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id B4DAF11DB66A for ; Mon, 5 Jul 2021 15:29:02 +0000 (UTC) (envelope-from petefrench@ingresso.co.uk) Received: from constantine.ingresso.co.uk (constantine.ingresso.co.uk [IPv6:2001:470:6a18:411::3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4GJV324s6Sz4Wyp; Mon, 5 Jul 2021 15:29:02 +0000 (UTC) (envelope-from petefrench@ingresso.co.uk) Received: from [2001:470:6cc4:1:cd6:5836:ddba:7b54] (helo=balta.drayhouse.twisted.org.uk) by constantine.ingresso.co.uk with esmtpsa (TLS1.3) tls TLS_AES_128_GCM_SHA256 (Exim 4.94.2 (FreeBSD)) (envelope-from ) id 1m0QWr-000Npx-Do; Mon, 05 Jul 2021 15:29:01 +0000 Subject: Re: ZFS + mysql appears to be killing my SSD's To: Alan Somers Cc: Stefan Esser , FreeBSD Stable Mailing List References: <89c37c3e-22e8-006e-5826-33bd7db7739e@ingresso.co.uk> <2fd9b7e4-dc75-fedc-28d7-b98191167e6b@freebsd.org> <9c71d627-55b8-2464-6cc9-489e4ce98049@ingresso.co.uk> From: Pete French Message-ID: Date: Mon, 5 Jul 2021 16:29:00 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 List-Id: Production branch of FreeBSD source code List-Archive: https://lists.freebsd.org/archives/freebsd-stable List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-stable@freebsd.org X-BeenThere: freebsd-stable@freebsd.org MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-GB Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: 4GJV324s6Sz4Wyp X-Spamd-Bar: ---- Authentication-Results: mx1.freebsd.org; none X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[] X-Spam: Yes X-ThisMailContainsUnwantedMimeParts: N On 05/07/2021 15:51, Alan Somers wrote: > If you're using 4K sectors anyway, then GELI does not create any extra > write amplification.   But if you're extra paranoid and you use the "-T" > option to "geli attach", then GELI will block TRIM commands.  That could > hurt SSD lifetime.  But I don't think "-T" is the default.  You are > using 4K sectors, right?  ZFS's ashift is set to 12? > -Alan Yup, 4k sectors, and I initialised geli telling it to present as 4k sectors. Am glad to hear that it wont amplify writes - thats what I assumed, but nice to have it confirmed. -pete.