Re: Slowness
Leonids,
Do you use OPTCOMPIND 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