#BTRFS advice.
This is a Filesystem that can do really awesome things... but it's worth noting that some of those things generate LOTS of fragmentation.
On SSDs this won't matter too much.
On Spinnybois though? Definitely be mindful of what you're doing or you'll feel every bit of that.
I generally run with 'autodefrag' and on HDDs with 'nodatacow' in my mount options. CopyOnWrite generates fragmentation over the course of normal use.
That does NOT mean that CopyOnWrite never happens. It means it doesn't happen when it doesn't *have* to. If you dedupe files with duperemove, create snapshots or make reflink copies, it STILL happens.
Moral of the story, please do not duperemove your databases on a spinnyboi. I had an app go from taking a minute or two to open to just 5 seconds just by defragging the databases.

