Oninit cdi / Archive
Talk to an expert →

Re: Slowness

Posted in 2000

Vinod Bhansali — — source: Informix-list mailing list archive (1991-1998)

Leonids, Do you use OPTCOMPIND 0 for OLTP system? I have also read that OPTCOMPIND should be 0 for OLTP and 2 for DSS systems. But I haven't tried that yet. We use OPTCOMPIND 1. Thanks in advance for you reply, Vinod Bhansali >>From: Leonids.Voroncovs@dati.lv >>Reply-To: Leonids.Voroncovs@dati.lv >>To: informix-list@iiug.org >>Subject: Re: Slowness >>Date: Fri, 16 Jun 2000 09:54:58 +0200 >> >>Boscia wrote: >> >> > Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 8 days >>14:54:51 >> > -- 491520 Kbytes >> >>How much memory You have? OS needs some memory too. >> >> >> > ROOTSIZE 1500000 # Size of root dbspace (Kbytes)>> >>You need such a big rootdbs really? Only 3 Mb in use (from "onstat -d"). >> >> >> > PHYSFILE 10000 # Physical log file size (Kbytes)>> >>50000 should be better IMHO. >> >> >> > TBLSPACE_STATS 1>> >>This parameter is usable for tuning, so turn it off ( 0 ). >> >> >> > DBSERVERNAME pinkfloyd # Name of default database server>> >>I like this band too :-) >> >> >> > BUFFERS 200000 # Maximum number of shared buffers>> >>Buffers should occupy from 1/4 to 1/2 of available memory. Monitoring >>needed. >> >> >> > LRUS 4 # Number of LRU queues>> >>Very long queues, try 128. >> >> >> > CLEANERS 4 # Number of buffer cleaner processes>> >>One cleaner per queue (128)? Too much i think. My guess is about 80. >> >> >> > SHMVIRTSIZE 8192 # initial virtual shared memory segment>>size >> >>See "onstat -g seg", server should allocate one virtual memory segment, >>try >>90000. >> >> >> >> > LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning>>limit >> > LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit>> >>MAX / MIN = 1 / 0 will be good enough. >> >> >> > OFF_RECVRY_THREADS 10 # Default number of offline worker>>threads >> >>Not needed. Set it to 1. >> >> >> > DUMPSHMEM 1 # Dump a copy of shared memory>> >>It is useless, set it to 0. >> >> >> > OPTCOMPIND 2 # To hint the optimizer>> >>I prefer 0. >> >> >> > Robin >> >>Leonid >> >> > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Related threads