Re: Should SQLite users be setting barrier=1?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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:

  http://www.sqlite.org/draft/lockingv3.html#ext3-barrier-problem

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

Thanks again,
Dan.


_______________________________________________
Ext3-users mailing list
Ext3-users@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/ext3-users


[Index of Archives]         [Linux RAID]     [Kernel Development]     [Red Hat Install]     [Video 4 Linux]     [Postgresql]     [Fedora]     [Gimp]     [Yosemite News]

  Powered by Linux