Joshua D. Drake wrote:
>full_page_writes = off is the problem.
>Turning this parameter off speeds normal operation, but might lead to
>either unrecoverable data corruption, or silent data corruption,
>after a system failure. The risks are similar to turning off fsync,
>though smaller, and it should be turned off only based on the same
>circumstances recommended for that parameter.
Well, silent data corruption would have been "ok" (to a certain extent).
Unrecoverable data corruption would be ok too, if it would only imply
losing some of the more recent parts of the data (at least for this database).
--
Stephen.
"Reality is merely an illusion,albeit a very persistent one." -- Albert Einstein