On Fri, Sep 22, 2006 at 01:52:02PM -0400, Jim Nasby wrote: > I thought folks might be interested in this... note in particular the > comment about linux. ... > >From: Greg 'groggy' Lehey <[EMAIL PROTECTED]> > >Date: June 26, 2006 11:34:12 PM EDT > >To: leo huang <[EMAIL PROTECTED]> > >Cc: freebsd-performance@freebsd.org > >Subject: Re: Is the fsync() fake on FreeBSD6.1? > >... > >My understanding from the last time I looked at the code was that > >fsync does the right thing: > > > > The fsync() system call causes all modified data and > >attributes of fd to > > be moved to a permanent storage device. This normally results > >in all in- > > core modified copies of buffers for the associated file to be > >written to > > a disk. > > > >This is not the case for Linux, where fsync syncs the entire file > >system. That could explain some of the performance difference, but > >not all of it. I suppose it's worth noting that, in general, people > >report much better performance with MySQL on Linux than on FreeBSD.
I see Greg's comment as contradictory. People see better performance with MySQL on Linux than on FreeBSD, fsync() on Linux syncs the whole file system? I don't believe that fsync() on Linux syncs the whole file system either. This sounds made up, or a confusion with 'sync'. Perhaps people @FreeBSD.org are not as familiar with Linux. Cheers, mark -- [EMAIL PROTECTED] / [EMAIL PROTECTED] / [EMAIL PROTECTED] __________________________ . . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder |\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ | | | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada One ring to rule them all, one ring to find them, one ring to bring them all and in the darkness bind them... http://mark.mielke.cc/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend