3 ms·
Any Windows experts about? I'm curious if it offers something better than fsync for this type of thing. Or perhaps nothing in the OS can really deal with the v
by tyingq 9y ago
Any Windows experts about? I'm curious if it offers something better than fsync for this type of thing.
Or perhaps nothing in the OS can really deal with the variety of behavior in disk controllers?
It's kind of funny to me that we're this many years into databases and hardware and no solution has ever emerged.
I suspect mainframes, for example, don't have this issue. Easy to solve when you get to spec every piece of hardware.
- zaarn 9y agoThe OS can't do anything. The Controller says "Fsync? Sure thing." and that's basically end of the story. Unless the cache is visible to the OS, the OS simply has to accept what the controller says as truth. The issue of a controller lying is to my experience very rare and only really exists for very cheap harddrives, SSDs or SD cards (interesting for RPi). I'm not aware of an enterprise hardware that does this, I suspect if anyone tried they'd be out of business quick.