Date: Mon, 5 Jul 2021 14:15:10 +0100 From: Pete French <petefrench@ingresso.co.uk> To: FreeBSD Stable Mailing List <freebsd-stable@freebsd.org> Subject: ZFS + mysql appears to be killing my SSD's Message-ID: <89c37c3e-22e8-006e-5826-33bd7db7739e@ingresso.co.uk>
next in thread | raw e-mail | index | archive | help
I hve a netwkr of FreeBSD machines which are running mysql on top of zfs. I have been doing this for a while, but a couple of years ago we switched to using SSD. After less than a year (I dont remember the exact timings), they all strated to fail. We assumed a bad batch, and had them replaced, and didnt think anything more of it. A week or so, all the replacements started to fail. This was shortly after I upgraded to FreeBSD 13 and OpenZFS, but I think this is unrelated, however its one major chnage which happened before the most recent round of failures. The thing is though, that I am not seieng any heavy activity on the drives. The load is sustained, but well below the lifetime write thresh-hold for the drive. I also do not see the drives a being heavily in use when I run gstat. So its perplexing. I am assuming its related to the mysql load, as this is identical across all machines, and they are all dying within a few days of each other. Any insights would be appreciated... :-) -pete.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?89c37c3e-22e8-006e-5826-33bd7db7739e>