Buffers not flushed

Posted in 2010

Jeremiah Leong — Wed, 29 Sep 2010 07:46:20 -0700 (PDT) — source: Usenet: comp.databases.informix

Is a high number on the buffers not flushed something to be concerned about? Fuzzy Checkpoint Completed: duration was 0 seconds, 36941 buffers not flushed.

↪ replying to Jeremiah Leong

caver — Thu, 30 Sep 2010 14:36:02 -0700 (PDT) — source: Usenet: comp.databases.informix

On Sep 29, 10:46 am, Jeremiah Leong <yogensha4e...@gmail.com> wrote: > Is a high number on the buffers not flushed something to be concerned > about? > > Fuzzy Checkpoint Completed: duration was 0 seconds, 36941 buffers not > flushed. If the fuzzy checkpoints are not written to disk (still in memory) AND your system goes down, you will loose the transactions.

↪ replying to caver

Superboer — Fri, 1 Oct 2010 08:27:36 -0700 (PDT) — source: Usenet: comp.databases.informix

> If the fuzzy checkpoints are not written to disk (still in memory) AND > your system goes down, you will loose the transactions. > From that standpoint, it is risky to let too many buffers accumulate > in a fuzzy checkpoint (in memory). BULLSHIT. The fast recovery mechanism works different when fuzzy checkpoints are used. it does not loose transactions. it will take longer to recover. Superboer.

Glossary

checkpoint