Re: performance turning help

Posted in 1999

Yuri Dovgart — Sat, 26 Jun 1999 10:32:02 GMT — source: Informix-list mailing list archive (1991-1998)

> My Informix seen to run slow and not taking > full CPU resource. I would ppreciate any help I can get on this problem. See recomendations for NOAGE param. > NOAGE 0 # Process aging Set to 1. It's critical for processes priority. > NUMAIOVPS 1 # Number of IO vps You are using kaio ? If not, increase NUMAIOVPS to at minimum the number of your active disks. > CLEANERS 4 # Number of buffer cleaner processes Increase CLEANERS, if you'll increase LRUS. Something about 16. > LRUS 12 # Number of LRU queues Increase LRUS to at minimum 128. For 600 K buffers 12 is too low. > DBSPACETEMP tempdbs # Default temp dbspaces Is it enough ? Probably you need additional temp spaces. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.