Buffers not flushed

#1

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.

#2

On Sep 29, 10:46*am, Jeremiah Leong <yogensha4e... (AT) gmail (DOT) com> wrote:

Quote:

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.
From that standpoint, it is risky to let too many buffers accumulate
in a fuzzy checkpoint (in memory).

#3

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Buffers not flushed

comp.databases.informix comp.databases.informix

Buffers not flushed - 09-29-2010 , 09:46 AM

Re: Buffers not flushed - 09-30-2010 , 04:36 PM

Re: Buffers not flushed - 10-01-2010 , 10:27 AM