Re: long checkpoints on informix

On Jul 18, 5:12 pm, Darin <dtrac...@gmail.com> wrote: > It looks like you have ~2800 dirty buffers, of which ~400+ are not > flushed during the checkpoint (fuzzy). Flushing ~2400 buffers should > not take 10+ seconds, so you need to find where the delay is. Try <SNIP> It will take 10 seconds to flush 2400 buffers if he's using flipping slow RAID5 disk! I KNOW what the problem is. I'd be willing to put $$ on it! Post OS level stats on the RAID5 array using the vendor's or OS's reporting software so we can all see where the real bottleneck is! Art S. Kagel

On 19 jul, 11:28, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Jul 18, 5:12 pm, Darin <dtrac...@gmail.com> wrote:> It looks like you have ~2800 dirty buffers, of which ~400+ are not > > flushed during the checkpoint (fuzzy). Flushing ~2400 buffers should > > not take 10+ seconds, so you need to find where the delay is. Try > > <SNIP> > > It will take 10 seconds to flush 2400 buffers if he's using flipping > slow RAID5 disk! > > I KNOW what the problem is. I'd be willing to put $$ on it! > > Post OS level stats on the RAID5 array using the vendor's or OS's > reporting software so we can all see where the real bottleneck is! > > Art S. Kagel im very sorry but some people give bad information about the server, when i was checking intrity of raid, i found there is not RAID5 is a RAID1 so no problem with that, sorry for give bad information, but someone document it was RAiD5