Re: System tuning

informix@asl3.asl-labs.bc.ca (Informix Sysadmin) wrote: >Hi...running the online engine v7.1 >We have been having performance nightmares, so we have been attempting to >modify some parameters, however we appear to be unable to decipher many >of the outputs from the onstat command. Most recently, we increased our >BUFFERS value, and the output from onstat -g glo changed from having all >the time go to AIO vp's to CPU vp's. Can anyone decipher this occurance? >Does that mean that we WERE blocked on AIO, but now are blocked on CPU? >Why can't there be a comprehensive explanation of ALL the output of >onstat ?????? What's the use of all these stats tools when they don't >explain what is good, what is NOT good :( >B. > ------------------------------------------------------------------------- > |Brian P. Hampson Internet : brian@asl-labs.bc.ca | > |System Administrator, Air(2m/70cm): VE7NNW | > |Analytical Service Labs Fidonet : Brian Hampson 1:153/733| > |Vancouver, BC | > |+604-253-4188 | > | Specialists in Environmental Chemistry | > | | > ------------------http://www.asl-labs.bc.ca/----------------------------- I would get the unix admin. to check for paging and swapping. You may have moved the io out of informix and put it on the os. Informix 7.1 does take more system overhead than 5.x and with the small amount of memory you have you may have overloaded the os when you increased the buffers. Raid 5 cost you on performance if you have a high updated system -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com