[lkml]   [1997]   [May]   [9]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
Messages in this thread
SubjectRe: Raw devices (Was:Re: NTFS, FAT32, etc.)
Martin von Loewis wrote:
> However, I thought that databases are interested in guaranteed completion,
> i.e. once write(2) returns, the system should guarantee that the data is
> really on disk. This is necessary for the transactional properties.

Oracle7 writes *synchronously* changes made to data blocks in its
redo log files. When that is done, Oracle uses AIO (if you turned
the option on, of course ;) to write full database blocks on the
data files. If the system crashes between the two, Oracle will do
crash recovery reading from the redo logs.

Serious databases never trust the hardware :)


--alessandro <> <>

Linux-i386 kernel-2.1.36 libc-5.4.23 gcc- binutils-

 \ /
  Last update: 2005-03-22 13:39    [W:0.065 / U:0.328 seconds]
©2003-2018 Jasper Spaans|hosted at Digital Ocean and TransIP|Read the blog|Advertise on this site