Re: fsync = true beneficial on ext3?

FYI - Ext3 has 3 modes :

data=ordered(default) : metadata is journaled (at write time data is
written before metadata - i.e ordered)
data=journal: data and metadata are journaled
data=writeback: metadata journaled (no ordering at write time)

The default will not help to protect database integrity if fsync is
false (as only metadata is journaled)

Will data=journal mode help? I am uncertain. A casual reading if these
definitions suggests that it *might* - anyone know for sure?

regards

Mark


Richard Welty wrote:

>
>by default, it journals everything, but you can set it to journal metadata
>only, i think with the mount option data=writeback. do a "man mount"
>and look for ext3 options for details on the data= option.
>
>
>
>