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 root dbspace >> 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 mirrored root >> 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 in distributed >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 vps to>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 cleaning limit >> 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 # 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 /u5/informix/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_DSLOCKWAIT 5 # DS lockwait timeout (seconds) >> CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR >queue (Kb >> ytes)>> >> # Backup/Restore variables@@NL