[jira] [Commented] (DERBY-5691) Recommend disabling Write Caching for on Windows

["Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-5691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256766#comment-13256766 ] 

Kathey Marsden commented on DERBY-5691:
---------------------------------------

Actually the general requirement that write caching  on the drive holding the derby database be disabled in order to insure data integrity should be documented as a requirement for all platforms and state that many platforms, e.g. Windows is enabled by default.

Other potential sync issues should be documented  as possible causes of corruption
- Running Derby on a NFS mounted  disk
- Using runtime compression which can cause sync to fail on disk full.

In general Derby needs to know that the sync  has absolutely written the data to disk in order to ensure recovery,






                
> Recommend disabling Write Caching  for on Windows
> -------------------------------------------------
>
>                 Key: DERBY-5691
>                 URL: https://issues.apache.org/jira/browse/DERBY-5691
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>         Environment: Microsoft Windows
>            Reporter: Stan Bradbury
>              Labels: Write_caching
>
> Suggestion that we document a recommendation that Windows Write Caching be disabled on machines using Derby.
> The following article warns about Write Caching on Windows as a possbile source of database corruption:
>      http://support.microsoft.com/kb/281672
> It is possible that this could be the cause of some unexplained Derby corruptions identified after power failure of other system interupt.
> Links explaining how to disable Write Caching:
>   Win 2K: http://support.microsoft.com/kb/259716
>    Win 2008: http://support.microsoft.com/kb/324805
> From the Windows 2008 article:
> With some third-party programs, disk write caching has to be turned on or off. Additionally, turning disk write caching on may increase operating system performance; however, it may also result in the loss of information if a power failure, equipment failure, or software failure occurs. This article describes how to turn disk write caching on or off.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira