Re: Need for Speed...
I was not speaking, if I remember right, to the number of LRUS. I was
stating that CLEANERS may need to be adjusted upwards to match the number of
LRUS; however, with the WRITE Cache at such a low value (48%), he might wind
up needing to add buffers.
Take care.
Clifton
----- Original Message -----
From: "William Rice" <ricew@operamail.com>
To: "Clifton M. Bean" <cmbean@home.com>; "informix-list"
<informix-list@iiug.org>
Sent: Sunday, May 07, 2000 8:14 AM
Subject: RE: Need for Speed...
> >===== Original Message From "Clifton M. Bean" <cmbean@home.com> =====
> <SNIP>
> >> CLEANERS 33 # Number of buffer cleaner processes
> >> LRUS 65 # Number of LRU queues>
> Given a BUFFERS value of 50000 I think having 65 LRU's is reasonable.
> breaking the buffers up into around 750 BUFFERS per LRU. This should
> make bufwaits due to locks on a LRU pretty unlikely.
> <SNIP>
>
> ><jmorales@nettaxi.com> wrote in message
> >news:8ev6ki$q6q$1@news.xmission.com...
> >>
> >> Hi Gurus,
> >>
> >> First of all thanks for the response.
> >>
> >> Here are the stats....
> >>
> >>
> >> -------------------------------------------------------------
> >> ROWS SIZE
> >> TABLE1 - 629649
> >> TABLE2 - 487323
> >> TABLE3 - 631455
> >>
> >> -------------------------------------------------------------
> >> onstat -c> >>
> >> Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up
03:35:05 --
> >1018936
> >> Kbytes
> >>
> >> Configuration File: /u5/informix/etc/onconfig
> >>
>
>#**************************************************************************
> >> #
> >> # INFORMIX SOFTWARE, INC.
> >> #
> >> # Title: onconfig
> >> # Description: Informix Dynamic Server Configuration Parameters
> >> #
> >>
>
>#**************************************************************************
> >>
> >> # Root Dbspace Configuration
> >>
> >> ROOTNAME root1db # Root dbspace name
> >> ROOTPATH /dev/infbroot # Path for device containing rootdbspace
> >> ROOTOFFSET 0 # Offset of root dbspace into device
> >(Kbytes)
> >> ROOTSIZE 2000000 # Size of root dbspace (Kbytes)> >>
> >> # Disk Mirroring Configuration Parameters
> >>
> >> MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
> >> MIRRORPATH # Path for device containing mirroredroot
> >> MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> >>
> >
> >> # Physical Log Configuration
> >>
> >> PHYSDBS root1db # Location (dbspace) of physical log
> >> PHYSFILE 50000 # Physical log file size (Kbytes)> >>
> >> # Logical Log Configuration
> >>
> >> LOGFILES 40 # Number of logical log files
> >> LOGSIZE 8192 # Logical log size (Kbytes)> >>
> >> # Diagnostics
> >>
> >> MSGPATH /u5/informix/log/palawan1.log # System message log file
> >path
> >> CONSOLE /dev/console # System console message path
> >> ALARMPROGRAM /u5/informix/etc/log_full.sh # Alarm program path> >> SYSALARMPROGRAM /u5/informix/etc/evidence.sh # System Alarm program
path
> >> TBLSPACE_STATS 1> >>
> >> # System Archive Tape Device
> >>
> >> #TAPEDEV /dev/null # Tape device path
> >> TAPEDEV /dev/rmt/1m # Tape device path
> >> TAPEBLK 16 # Tape block size (Kbytes)
> >> TAPESIZE 24000000 # Maximum amount of data to put on tape
> >(Kbytes)> >>
> >> # Log Archive Tape Device
> >>
> >> LTAPEDEV /dev/rmt/2m # Log tape device path
> >> LTAPEBLK 16 # Log tape block size (Kbytes)
> >> LTAPESIZE 24000000 # Max amount of data to put on log tape
> >(Kbytes)> >>
> >> # Optical
> >>
> >> STAGEBLOB # Informix Dynamic Server/Optical
staging
> >area
> >>
> >> # System Configuration
> >>
> >> SERVERNUM 1 # Unique id corresponding to a Dynamic> >Server in
> >> stance
> >> DBSERVERNAME jose1tcp # Name of default database server
> >> DBSERVERALIASES jose1ipc # List of alternate dbservernames
> >> NETTYPE ipcshm,2,70,NET # Configure poll thread(s) for nettype
> >> NETTYPE soctcp,9,70,NET # Configure poll thread(s) for nettype
> >> DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed
> >env.
> >> RESIDENT 1 # Forced residency flag (Yes = 1, No =
0)
> >>
> >> MULTIPROCESSOR 1 # 0 for single-processor, 1 for> >multi-processor
> >> NUMCPUVPS 3 # Number of user (cpu) vps
> >> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto
> >one
> >>
> >> NOAGE 1 # Process aging
> >> AFF_SPROC 0 # Affinity start processor
> >> AFF_NPROCS 0 # Affinity number of processors> >>
> >> # Shared Memory Parameters
> >>
> >> LOCKS 200000 # Maximum number of locks
> >> BUFFERS 50000 # Maximum number of shared buffers
> >> NUMAIOVPS 12 # Number of IO vps
> >> PHYSBUFF 128 # Physical log buffer size (Kbytes)
> >> LOGBUFF 128 # Logical log buffer size (Kbytes)> >> LOGSMAX 100 # Maximum number of logical log files
> >> CLEANERS 33 # Number of buffer cleaner processes
> >> SHMBASE 0x0 # Shared memory base address
> >> SHMVIRTSIZE 900000 # initial virtual shared memory segment> >size
> >> SHMADD 32000 # Size of new shared memory segments
> >(Kbytes)
> >> SHMTOTAL 0 # Total shared memory (Kbytes).
> >0=>unlimited
> >> CKPTINTVL 3000 # Check point interval (in sec)
> >> LRUS 65 # Number of LRU queues
> >> LRU_MAX_DIRTY 80 # LRU percent dirty begin cleaninglimit
> >> LRU_MIN_DIRTY 70 # LRU percent dirty end cleaning limit
> >> LTXHWM 50 # Long transaction high water mark> >percentage
> >> LTXEHWM 60 # Long transaction high water mark
> >(exclusive)
> >> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> >> STACKSIZE 32 # Stack size (Kbytes)> >>
> >> # System Page Size
> >> # BUFFSIZE - Dynamic Server no longer supports this configuration
> >parameter.
> >> # To determine the page size used by Dynamic Server on your
> >platform
> >> # see the last line of output from the command, 'onstat -b'.
> >>
> >>
> >> # Recovery Variables
> >> # OFF_RECVRY_THREADS:
> >> # Number of parallel worker threads during fast recovery or an offline
> >restore.
> >> # ON_RECVRY_THREADS:
> >> # Number of parallel worker threads during an online restore.
> >> OFF_RECVRY_THREADS 10 # Def