On Sat, 2018-03-10 at 14:04 +0200, Nikolay Borisov wrote: > So for OLTP workloads you definitely want nodatacow enabled, bear in > mind this also disables crc checksumming, but your db engine should > already have such functionality implemented in it.
Unlike repeated claims made here on the list and other places... I woudln't now *any* DB system which actually does this per default and or in a way that would be comparable to filesystem lvl checksumming. Look back in the archives... when I've asked several times for checksumming support *with* nodatacow, I evaluated the existing status for the big ones (postgres,mysql,sqlite,bdb)... and all of them had this either not enabled per default, not at all, or requiring special support for the program using the DB. Similar btw: no single VM image type I've evaluated back then had any form of checksumming integrated. Still, one of the major deficiencies (not in comparison to other fs, but in comparison to how it should be) of btrfs unfortunately :-( Cheers, Chris. -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majord...@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html
