[lkml]   [2005]   [May]   [30]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
Messages in this thread
    SubjectRe: Linux does not care for data integrity (was: Disk write cache)
    Matthias Andree <> writes:

    > On Sun, 29 May 2005, Greg Stark wrote:
    > > They meet this requirement just fine on SCSI drives (where write caching
    > > generally ships disabled) and on any OS where fsync issues a cache flush. If
    > I don't know what facts "generally ships disabled" is based on, all of
    > the more recent SCSI drives (non SCA type though) I acquired came with
    > write cache enabled and some also with queue algorithm modifier set to 1.

    People routinely post "Why does this cheap IDE drive outperform my shiny new
    high end SCSI drive?" questions to the postgres mailing list. To which people
    point out the IDE numbers they've presented are physically impossible for a
    7200 RPM drive and the SCSI numbers agree appropriately with an average
    rotational latency calculated from whatever speed their SCSI drives are.

    > > Worse, if the disk flushes the data to disk out of order it's quite
    > > likely the entire database will be corrupted on any simple power
    > > outage. I'm not clear whether that's the case for any common drives.
    > It's a matter of enforcing write order. In how far such ordering
    > constraints are propagated by file systems, VFS layer, down to the
    > hardware, is the grand question.

    Well guaranteeing write order will at least mean the database isn't complete
    garbage after a power event.

    It still means lost transactions, something that isn't going to be acceptable
    for any real-life business where those transactions are actual dollars.


    To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
    the body of a message to
    More majordomo info at
    Please read the FAQ at

     \ /
      Last update: 2005-05-30 08:11    [W:0.020 / U:26.908 seconds]
    ©2003-2017 Jasper Spaans. hosted at Digital OceanAdvertise on this site