Skip to main content
Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • 2
    While its a good question, I think you will get mainly opinion based answers. I don't think the problem is likely to be BTRFS here. I don't use BTRFS but I do use ZFS which is also uses COW - and I've not had any failures for many years. I think it may just be bad luck with the drives, or maybe a vibration issue or similar? Could it be heat related? Are all the drives the same make, model and age? Commented Sep 3, 2024 at 10:46
  • 1
    Though SSD's have limited write cycles, even when over-provisioned, they are more likely to fail than HDD's from such use. Look to overheating, environment (e.g., power glitches, air quality...) or other cause of HDD failure. Commented Sep 3, 2024 at 14:06
  • Thanks @DrMoishePippik, @ davidgo, I've looked at various things and BTRFS still isn't the most likely, but I just realized how bad DB workloads would be on BTRFS and thought maybe there's someone who has an insight into this. Commented Sep 3, 2024 at 17:11
  • I have a (not BTRFS) database on a M.2 SSD for a more than a year with no issues. It records dozens of sensors readings like temperature humidity and etc in addition to 50+ volt,amps,watt sensors every minute of every day. A lot of the changes are probably buffered through the DRAM cache. Commented Sep 5, 2024 at 14:51