Re: ZFS + mysql appears to be killing my SSD's

From: Pete French <petefrench_at_ingresso.co.uk>
Date: Mon, 05 Jul 2021 15:29:00 UTC

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.