Re: System tuning

This is a multi-part message in MIME format. --------------64177A585579 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Informix Sysadmin wrote: > 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? It means that with fewer buffers to hold data, you had to read more of the data from disk. AIO vps do the job of reading/writing data from/to disk. With the increased number of buffers, you are simply doing LESS I/O. I can't say whether or not you are "blocked" on CPU - does vmstat/sar show any idle time? If not, then you are out of cpu. If there is idle/wait time, then something else is the bottleneck. > 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 :( No comment. -- Dave Kosenko, Informix Professional Services **************************************************************************** While it is true that there is more than one way to skin a cat, the cat himself generally fails to appreciate the differences. --------------64177A585579 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="IFXDISCL.TXT" ************************************************************************* Note: please do not send me email asking about features, or asking about Informix problems and how to solve them. I answer what questions I can in this forum (comp.databases.informix) when I have the time to spare. For questions on features, call your local sales rep or check out the Informix web site (http://www.informix.com). For technical problems, call Informix tech support. ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------64177A585579--