Should SQLite users be setting barrier=1?

Dan Kennedy danielk1977 at
Tue Jul 13 16:56:24 UTC 2010

> If you do not use barriers, your storage device could very well lose  
> data if it loses power. There is no easy answer, you need to  
> understand the type and configuration of your storage.
> For a local SAS/S-ATA drive, you should have barriers enabled when  
> the write cache is enabled (check that with hdparm for example on S- 
> ATA). Note that you could also be safe by disabling the write cache  
> and leaving barriers off as well.
> If you have a non-volatile write cache (for example on an external,  
> enterprise class array), you can safely mount without barriers.
> Regards,
> Ric

Hi Ric,

Thanks very much for the quick response (and Eric, thanks
as well).

Richard put a paragraph with a link to your answer in
our documentation here:

Please let us know if this misrepresents the situation.
Or if there is something else we should add to clarify

Thanks again,

More information about the Ext3-users mailing list