Re: System tuning

informix@asl3.asl-labs.bc.ca (Informix Sysadmin) wrote: >On Mon, 25 Mar 1996, tolly brumbelow wrote: >> informix@asl3.asl-labs.bc.ca (Informix Sysadmin) wrote: >> >> 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. >As luck would have it....I _AM_ the UNIX sysadmin <grin>. The I/O is >100% raw disk, so the OS shouldn't be doing anything. >> Informix 7.1 does take more system overhead than 5.x and with the >> small amount of memory you have >I am wondering about this. Is there any way to be able to say "We have X >data points, in y tables, and z users" to know how much mem or CPU is good? >> you may have overloaded the os when >> you increased the buffers. >I was afraid that this may have been possible, but it didn't appear to >indicate that from it's behaviour. >> Raid 5 cost you on performance if you have a high updated system >Reads outnumber writes 28:1 >Cheers, >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 am not talking about informix io. When you set up unix you set up cooked devices for swap space and if you are trying to use more memory than you have the unix box will start swapping to this disk swap space which is a unix io. Informix at this time has no control or no statistics about this io but it has to wait on it just the same. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com