ZFS + mysql appears to be killing my SSD's
- Reply: Stefan Esser : "Re: ZFS + mysql appears to be killing my SSD's"
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Mon, 05 Jul 2021 13:15:10 UTC
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.