Re: suggestion reqd Perf tuning
is there any more suggestions?
Please post your view.
regards
madhu
darko wrote:
> madh wrote:
> > this my onconfig file. I am using Informix Dynamic Server Version
> > 7.31.UD6W4, HP-UX 11.11 ,
> > no of cpus- 2, REPORT SERVER (used for creating report purposes).
> > Memory 1387036K(1260472k) real, 1847708K (1682688k), virtual 4262876k
> > free pages,
> > Just want see some imporovement in cpu perf.
> >
> > shall i set AFF_NPROCS = 1 ,
> >
> > ROOTNAME prd_my_rootdbs # Root dbspace name> >
> >
> > ROOTPATH /dev/infdevprd_my/prd_my_rootdbs.1
> >
> >
> > # Path for device containing root
> > dbspace
> > ROOTOFFSET 0 # Offset of root dbspace into device
> > (Kbytes)
> > ROOTSIZE 512000 # Size of root dbspace (Kbytes)> >
> >
> > # Disk Mirroring Configuration Parameters
> >
> >
> > MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
> >
> >
> > MIRRORPATH # Path for device containing mirrored> > root
> > MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> >
> >
> > # Physical Log Configuration
> >
> >
> > PHYSDBS prd_my_plogdbs1 # Location (dbspace) of physical log
> >
> >
> > PHYSFILE 200000 # Physical log file size (Kbytes)> >
> >
> > # Logical Log Configuration
> >
> >
> > LOGFILES 40 # Number of logical log files> >
> >
> > LOGSIZE 50000 # Logical log size (Kbytes)> >
> >
> > # Diagnostics
> >
> >
> > MPATH /usr/informix__prd_my/logs/prd_my_srv.log
> >
> >
> > # System message log file path
> >
> >
> > CONSOLE /dev/console # System console message path> >
> >
> > ALARMPROGRAM /usr/informix_prd_my/etc/no_log.sh # Alarm program
> > path SYSALARMPROGRAM /usr/informix__prd_my/etc/evidence.sh
> >
> >
> > # System Alarm program path
> >
> >
> > TBLSPACE_STATS 1> >
> >
> > # System Archive Tape Device
> >
> >
> > TAPEDEV /dev/null # Tape device path> >
> >
> > TAPEBLK 512 # Tape block size (Kbytes)> >
> >
> > TAPESIZE 80000000 # Maximum amount of data to put on tape> >
> > (Kbytes)
> >
> >
> > # Log Archive Tape Device
> >
> >
> > LTAPEDEV /dev/null # Log tape device path> >
> >
> > LTAPEBLK 512 # Log tape block size (Kbytes)> >
> >
> > LTAPESIZE 8000000 # Max amount of data to put on log tape> >
> > (Kbytes)
> >
> >
> > # Optical
> >
> >
> > STAGEBLOB # Informix Dynamic Server/Optical
> > staging area
> >
> >
> > # System Configuration
> >
> >
> > SERVERNUM 3 # Unique id corresponding to a Dynamic> > Server in
> > stance
> >
> >
> > DBSERVERNAME prd_my_srv # Name of default database server> >
> >
> > DBSERVERALIASES # List of alternate dbservernames> >
> >
> > NETTYPE soctcp,2,150,NET # Configure poll thread(s) for nettype> >
> >
> >
> > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> > distributed env.
> > RESIDENT 1 # Forced residency flag (Yes = 1, No =
> > 0)> >
> >
> > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> > multi-processor
> > NUMCPUVPS 2 # Number of user (cpu) vps> >
> >
> > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> > to one
> >
> >
> > NOAGE 1 # Process aging> >
> >
> > AFF_SPROC 0 # Affinity start processor> >
> >
> > AFF_NPROCS 0 # Affinity number of processors> >
> >
> > # Shared Memory Parameters
> >
> >
> > LOCKS 500000 # Maximum number of locks> >
> >
> > BUFFERS 100000 # Maximum number of shared buffers> >
> >
> > NUMAIOVPS 30 # Number of IO vps> >
> >
> > PHYSBUFF 512 # Physical log buffer size (Kbytes)> >
> >
> > LOGBUFF 512 # Logical log buffer size (Kbytes)> >
> >
> > LOGSMAX 100 # Maximum number of logical log files
> >
> >
> > CLEANERS 20 # Number of buffer cleaner processes> >
> >
> > SHMBASE 0x0 # Shared memory base address> >
> >
> > SHMVIRTSIZE 256000 # initial virtual shared memory segment> >
> > size
> > SHMADD 128000 # Size of new shared memory segments
> > (Kbytes)
> > SHMTOTAL 0 # Total shared memory (Kbytes).
> > 0=>unlimited
> > CKPTINTVL 1200 # Check point interval (in sec)> >
> >
> > LRUS 127 # Number of LRU queues> >
> >
> > LRU_MAX_DIRTY 5 # LRU percent dirty begin cleaning> > limit
> > LRU_MIN_DIRTY 2 # 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
> >
> >
> > # 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 # Default number of offline worker> > threads
> > ON_RECVRY_THREADS 1 # Default number of online worker> > threads
> >
> >
> > # Data Replication Variables
> >
> >
> > # DRAUTO: 0 manual, 1 retain type, 2 reverse type
> >
> >
> > DRAUTO 0 # DR automatic switchover> >
> >
> > DRINTERVAL 30 # DR max time between DR buffer flushes> >
> > (in sec)
> > DRTIMEOUT 30 # DR network timeout (in sec)> >
> >
> > DRLOSTFOUND /usr/informix__prd_my/etc/dr.lostfound # DR lost+found
> > file path
> >
> >
> > # CDR Variables
> >
> >
> > CDR_LOGBUFFERS 2048 # size of log reading buffer pool
> > (Kbytes)
> > CDR_EVALTHREADS 1,2 # evaluator threads
> > (per-cpu-vp,additional)> > CDR