RE: take long time to complete checkpoint

From: "Ngo, Thanh" <t-ngo@ti.com> > >Thank you for your response. >This only happens when we load data to the tables. (Massive load) There's a couple of things you can try: 1. Increase LRU_MIN_DIRTY and LRU_MAX_DIRTY to 80 and 90. 2. Decrease them to 2 and 1. 3. Run checkpoints often during the load. 4. Run a checkpoint just before the load. But as was explained elsewhere, it's unlikely any of it would make much of a difference. The thing to try and achive is the lowest total checkpoint time. In other words, one 20 second checkpoint at the end of a load is probably less diruptive than 4 10-second checkpoints during the load. >-----Original Message----- >From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] > > >From: Thanh Ngo <t-ngo@ti.com> > > > >'online.log' shows me that it took about 77 seconds to complete a > >checkpoint. > >It is not like our other database > >engines, it only took about 3 or 5 second to complete the checkpoint. >Can > >someone tell me how to lower the time > >for this? Increasing LRUS can help? We have Informix version 7.31.UC5. > >I'd guess your server just did a lot of work, like (for instance) a massive >data load or update? > >Increasing CLEANERS and LRUS can help, as can decreasing your buffers or >checkpoint interval or shrinking your physical log. Be aware that any of >them could have other side effects, though. > >____________________________________________________________________________ >_________ >Get more from the Web. FREE MSN Explorer download : >http://explorer.msn.com _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com