Re: CPU usage problems when using KAIO in V7.3? on SINIX.

From: mike@inftec.be (Mike Aerts) I've forgotten where I was going on this one... :-) Still, let's see: (Can you resend these onstats after "normal" usage, too?) > > onstat -p> >Informixx Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:06:37 - > 76384 Kbytes > >Profile >dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >90536 88898 93259 2.92 13 8 3 0.00 I think you might need some more buffers. > > onstat -R> >Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:07:11 -- >76384 Kbytes > >8 buffer LRU queue pairs priority levels ># f/m pair total % of length LOW MED_LOW MED_HIGH HIGH > 0 f 876 100.0% 876 0 579 293 4 > 1 m 0.0% 0 0 0 0 0 > 2 f 876 100.0% 876 0 577 290 9 > 3 m 0.0% 0 0 0 0 0 > 4 f 876 100.0% 876 0 578 291 7 > 5 m 0.0% 0 0 0 0 0 > 6 f 876 100.0% 876 0 610 263 3 > 7 m 0.0% 0 0 0 0 0 > 8 f 874 100.0% 874 0 602 270 2 > 9 m 0.0% 0 0 0 0 0 >10 f 874 100.0% 874 0 611 258 5 >11 m 0.0% 0 0 0 0 0 >12 f 874 100.0% 874 0 584 282 8 >13 m 0.0% 0 0 0 0 0 >14 F 874 100.0% 874 0 595 269 10 >15 m 0.0% 0 0 0 0 0 >0 dirty, 7000 queued, 7000 total, 8192 hash buckets, 2048 buffer size >start clean at 60% (of pair total) dirty, or 525 buffs dirty, stop at 50% >0 priority downgrades, 0 priority upgrades Hmmm. Have you upgraded recently from 7.2x? > > onstat -F> > >Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:07:24 -- >76384 Kbytes > > >Fg Writes LRU Writes Chunk Writes >0 0 3 > >address flusher state data >24314504 0 I 0 = 0X0 >243149f0 1 I 0 = 0X0 > states: Exit Idle Chunk Lru > > > $INFORMIXDIR/etc/$ONCONFIG >LOGFILES 6 # Number of logical log files >LOGSIZE 20000 # Logical log size (Kbytes) I would rather go for 60 x 2000, but that's got nothing to do with your problem. >RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) Try setting to 1. >BUFFERS 7000 # Maximum number of shared buffers You *definitely* need more buffers. Try 32000 >PHYSBUFF 32 # Physical log buffer size (Kbytes) >LOGBUFF 32 # Logical log buffer size (Kbytes) You might tweak these too, but that's also got nothing to do with this problem. :-) >CLEANERS 2 # Number of buffer cleaner processes Try 9. But that's got nothing to do with this problem. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

I think you have something when you asked if there was a recent upgrade. I would check into bug 115327. The easiest way to tell if you have run into this bug is to monitor "onstat -P | tail" and see if the Btree % is high. There have been many emails about the different way to work around this, but getting the fix should do the trick. I believe this went into 7.31.UC4 and 7.30.UC10. Hope this helps, ---jmiller Obnoxio The Clown wrote: > From: mike@inftec.be (Mike Aerts) > > I've forgotten where I was going on this one... :-) > > Still, let's see: > > (Can you resend these onstats after "normal" usage, too?) > > > > onstat -p> > > >Informixx Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:06:37 - > > 76384 Kbytes > > > >Profile > >dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > >90536 88898 93259 2.92 13 8 3 0.00 > > I think you might need some more buffers. > > > > onstat -R> > > >Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:07:11 -- > >76384 Kbytes > > > >8 buffer LRU queue pairs priority levels > ># f/m pair total % of length LOW MED_LOW MED_HIGH HIGH > > 0 f 876 100.0% 876 0 579 293 4 > > 1 m 0.0% 0 0 0 0 0 > > 2 f 876 100.0% 876 0 577 290 9 > > 3 m 0.0% 0 0 0 0 0 > > 4 f 876 100.0% 876 0 578 291 7 > > 5 m 0.0% 0 0 0 0 0 > > 6 f 876 100.0% 876 0 610 263 3 > > 7 m 0.0% 0 0 0 0 0 > > 8 f 874 100.0% 874 0 602 270 2 > > 9 m 0.0% 0 0 0 0 0 > >10 f 874 100.0% 874 0 611 258 5 > >11 m 0.0% 0 0 0 0 0 > >12 f 874 100.0% 874 0 584 282 8 > >13 m 0.0% 0 0 0 0 0 > >14 F 874 100.0% 874 0 595 269 10 > >15 m 0.0% 0 0 0 0 0 > >0 dirty, 7000 queued, 7000 total, 8192 hash buckets, 2048 buffer size > >start clean at 60% (of pair total) dirty, or 525 buffs dirty, stop at 50% > >0 priority downgrades, 0 priority upgrades > > Hmmm. Have you upgraded recently from 7.2x? > > > > onstat -F> > > > > >Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:07:24 -- > >76384 Kbytes > > > > > >Fg Writes LRU Writes Chunk Writes > >0 0 3 > > > >address flusher state data > >24314504 0 I 0 = 0X0 > >243149f0 1 I 0 = 0X0 > > states: Exit Idle Chunk Lru > > > > > $INFORMIXDIR/etc/$ONCONFIG > > >LOGFILES 6 # Number of logical log files > >LOGSIZE 20000 # Logical log size (Kbytes)> > I would rather go for 60 x 2000, but that's got nothing to do with your > problem. > > >RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)> > Try setting to 1. > > >BUFFERS 7000 # Maximum number of shared buffers> > You *definitely* need more buffers. Try 32000 > > >PHYSBUFF 32 # Physical log buffer size (Kbytes) > >LOGBUFF 32 # Logical log buffer size (Kbytes)> > You might tweak these too, but that's also got nothing to do with this > problem. :-) > > >CLEANERS 2 # Number of buffer cleaner processes> > Try 9. But that's got nothing to do with this problem. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com