Re: long checkpoint duration

Hi Floyd, tell me what onstat -C shows you? Also onstat -C hot |wc -l would be nice as well. One of the bigger culprits in the old days was the btcleaner thread since it has to clean indices for the who instance, and the current defaults help make the btscanner thread just as big of a potential road block. The good news is that with the btscanner, you can fire off more threads. You can also enable range scanning as well. -Mark ----- Original Message ---- From: Floyd Wellershaus <floyd@fwellers.com> To: informix-list@iiug.org Sent: Tuesday, February 12, 2008 11:16:01 AM Subject: long checkpoint duration Hi, The age old question I guess. But our checkpoint durations are consistently near 20seconds. ids10.0 fc5 on ibm p570 running aix 5.3 7 cpus 41g ram. ckptintvl is 300, I am considering halving that. We have 128 lru's and 128 cleaners Art's ratio tool shows all good except a high btr. We have 2557440 buffers, but I am pretty sure if we add much more we'll start paging. Anyway , that probably isn't affecting the checkpoint. onstat -g iov shows the inverted pyramid with 7 kio threads. Aside from worrying about fragmentation and data distribution issues in our FastT900 san, is there anything I'm missing that I should look at real quick to reduce the chkpoint interval ? Thanks, Floyd -----Inline Attachment Follows----- _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list