RE: What does it mean "Fuzzy Checkpoint"?
Posted in 2000
This is the checkpoint standard that was promulgated by the GOP. It's how
you do checkpoints associated with fuzzy math.
;-)
cheers
j.
> -----Original Message-----
> From: Joanne Dority [mailto:joanned@seanet.com]
> Sent: Tuesday, November 28, 2000 8:14 AM
> To: informix-list@iiug.org
> Subject: Re: What does it mean "Fuzzy Checkpoint"?
>
>
> Systems that have too many dirty pages at checkpoint time,
> are very slow to
> checkpoint, even if you set LRU_MIN_DIRTY/LRU_MAX_DIRTY to very low
> numbers. So, fuzzy checkpoints were created to solve the
> "blocking" of
> user activity during a checkpoint. If you haven't experienced this
> problem, you may not see the advantage of fuzzy checkpoints.
>
> it is possible to get the full sync checkpoints as the
> default, if you set
> an environment variable -- but I don't know how its spelled.
> check with
> Informix.
>
>
> Neil Truby wrote in message <8vm55e$t01$1@taliesin2.netcom.net.uk>...
> >IDS 2000 introduces the concept of a "fuzzy checkpoint",
> whereby not all
> >dirty pages are written back to disk at checkpoint time. A
> change to the
> >recovery logic, involving the use of logical logs, has been made to
> >facilitate this. The advantage is that pages may be
> retained in cache for
> >longer, thus increasing the cache rates.
> >
> >I think it may be possible to disable it and have "real"
> checkpoints if
> >required. To be honest, though, in my experience it's pretty much
> >transparent to sys admins/DBAs.
> >
> >DH <huyv@usa.net> wrote in message
> news:975033368.383729@news.aei.ca...
> >> Hi all,
> >>
> >> I'm moving from IDS 7.30 to IDS2000 and still learning
> with it. There is
> >> some new term as "Fuzzy Checkpoint" in online.log that I
> don't see in IDS
> >> 7.30 for example:
> >>
> >> 17:00:14 Fuzzy Checkpoint Completed: duration was 0> seconds, 77 buffers
> >> not flushed.
> >> 17:00:14 Checkpoint loguniq 299, logpos 0x59f9c2a4
> >>
> >> Is there something different between IDS 7 and IDS2000 in
> checkpoint area
> >or
> >> not?
> >>
> >> Thanks in advance for any advise.
> >>
> >> DH.
> >>
> >>
> >>
> >
> >
>
>