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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
