special thanks and informix performance considerations

This is a multi-part message in MIME format. ------=_NextPart_000_0007_01BF5B85.BFC993A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I would like to thank all of you who help me to set up informix ids 7.30UC7 running on my linux system. (PII-350Mhz+128MB RAM). I was very disappointed with the performance compared with a NT 4.0+ IDS 7.30TC5 on the same machine. Both running on the same hardware/cooked files conf/database data, NT outperforms linux by far. I am using the default onconfig, just changed number of buffers. I hope that major changes should be made to my configuration, so any ideas are welcome. Please help quit using Micro$oft NT. Thanks id advance. Regards. Diego Mezzera. ------=_NextPart_000_0007_01BF5B85.BFC993A0 Content-Type: application/octet-stream; name="onconfig" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="onconfig" #************************************************************************= **=0A= #=0A= # INFORMIX SOFTWARE, INC.=0A= #=0A= # Title: onconfig.std=0A= # Description: Informix Dynamic Server Configuration Parameters=0A= #=0A= #************************************************************************= **=0A= =0A= # Root Dbspace Configuration=0A= =0A= ROOTNAME rootdbs # Root dbspace name=0A= ROOTPATH /info1/rootdbs.000 # Path for device containing root = dbspace=0A= ROOTOFFSET 0 # Offset of root dbspace into device = (Kbytes)=0A= ROOTSIZE 50000 # Size of root dbspace (Kbytes)=0A= =0A=# Disk Mirroring Configuration Parameters=0A= =0A= MIRROR 0 # Mirroring flag (Yes =3D 1, No =3D 0)=0A= MIRRORPATH # Path for device containing mirrored = root=0A= MIRROROFFSET 0 # Offset into mirrored device (Kbytes)=0A= =0A=# Physical Log Configuration=0A= =0A= PHYSDBS rootdbs # Location (dbspace) of physical log=0A= PHYSFILE 1000 # Physical log file size (Kbytes)=0A= =0A=# Logical Log Configuration=0A= =0A= LOGFILES 6 # Number of logical log files=0A= LOGSIZE 500 # Logical log size (Kbytes)=0A= =0A= # Diagnostics=0A= =0A=MSGPATH /opt/informix/online.log # System message log file path=0A= CONSOLE /dev/null # System console message path=0A= ALARMPROGRAM /opt/informix/etc/log_full.sh # Alarm program path=0A= SYSALARMPROGRAM /opt/informix/etc/evidence.sh # System Alarm program path=0A= TBLSPACE_STATS 1 =0A= =0A=# System Archive Tape Device=0A= =0A= TAPEDEV /dev/null # Tape device path =0A= TAPEBLK 16 # Tape block size (Kbytes)=0A= TAPESIZE 10240 # Maximum amount of data to put on tape = (Kbytes)=0A= =0A= # Log Archive Tape Device=0A= =0A= LTAPEDEV /dev/null # Log tape device path=0A= LTAPEBLK 16 # Log tape block size (Kbytes)=0A= LTAPESIZE 10240 # Max amount of data to put on log tape = (Kbytes)=0A= =0A= # Optical=0A= =0A=STAGEBLOB # Informix Dynamic Server/Optical = staging area=0A= =0A= # System Configuration=0A= =0A= SERVERNUM 0 # Unique id corresponding to a Dynamic = Server instance=0A= DBSERVERNAME ol_linuxshm # Name of default database server=0A= DBSERVERALIASES ol_linux # List of alternate dbservernames=0A= NETTYPE ipcshm,1,10,CPU # Configure poll thread(s) for nettype=0A= NETTYPE soctcp,1,10,NET # Configure poll thread(s) for nettype=0A= DEADLOCK_TIMEOUT 60 # Max time to wait of lock in = distributed env.=0A= RESIDENT 0 # Forced residency flag (Yes =3D 1, No = =3D 0)=0A= =0A= MULTIPROCESSOR 0 # 0 for single-processor, 1 for = multi-processor=0A= NUMCPUVPS 1 # Number of user (cpu) vps=0A= SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps = to one=0A= =0A=#NOAGE 0 # Process aging=0A= #AFF_SPROC 0 # Affinity start processor=0A= #AFF_NPROCS 0 # Affinity number of processors=0A= =0A= # Shared Memory Parameters=0A= =0A= LOCKS 2000 # Maximum number of locks=0A= BUFFERS 10000 # Maximum number of shared buffers=0A= NUMAIOVPS # Number of IO vps=0A= PHYSBUFF 32 # Physical log buffer size (Kbytes)=0A= LOGBUFF 32 # Logical log buffer size (Kbytes)=0A=LOGSMAX 6 # Maximum number of logical log files=0A= CLEANERS 1 # Number of buffer cleaner processes=0A= SHMBASE 0x10000000 # Shared memory base address=0A= SHMVIRTSIZE 8000 # initial virtual shared memory segment = size=0A= SHMADD 8192 # Size of new shared memory segments = (Kbytes)=0A= SHMTOTAL 0 # Total shared memory (Kbytes). = 0=3D>unlimited=0A= CKPTINTVL 300 # Check point interval (in sec)=0A= LRUS 4 # Number of LRU queues=0A= LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit=0A= LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit=0A= LTXHWM 50 # Long transaction high water mark = percentage=0A= LTXEHWM 60 # Long transaction high water mark = (exclusive)=0A= TXTIMEOUT 0x12c # Transaction timeout (in sec)=0A= STACKSIZE 32 # Stack size (Kbytes)=0A= =0A= # System Page Size=0A=# BUFFSIZE - Dynamic Server no longer supports this configuration = parameter.=0A= # To determine the page size used by Dynamic Server on your = platform=0A= # see the last line of output from the command, 'onstat -b'.=0A= =0A= =0A= # Recovery Variables=0A= # OFF_RECVRY_THREADS:=0A= # Number of parallel worker threads during fast recovery or an offline = restore.=0A= # ON_RECVRY_THREADS:=0A= # Number of parallel worker threads during an online restore.=0A= =0A= OFF_RECVRY_THREADS 10 # Default number of offline worker = threads=0A= ON_RECVRY_THREADS 1 # Default number of online worker = threads=0A= =0A=# Data Replication Variables=0A= # DRAUTO: 0 manual, 1 retain type, 2 reverse type=0A= DRAUTO 0 # DR automatic switchover=0A= DRINTERVAL 30 # DR max time between DR buffer flushes = (in sec)=0A= DRTIMEOUT 30 # DR network timeout (in sec)=0A= DRLOSTFOUND /opt/informix/etc/dr.lostfound # DR lost+found file path=0A= =0A= # CDR Variables=0A=CDR_LOGBUFFERS 2048 # size of log reading buffer pool = (Kbytes)=0A= CDR_EVALTHREADS 1,2 # evaluator threads = (per-cpu-vp,additional)=0A= CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)=0A= CDR_QUEUEMEM 4096

Hi! Get the BUFFERS way up. You can dedicate 30-40 MB to Informix. Others will follow with more detailed info, no doubt. Regards, Michael Diego wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_0007_01BF5B85.BFC993A0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > > Hi, > > I would like to thank all of you who help me to set up informix ids 7.30UC7 > running on my linux system. (PII-350Mhz+128MB RAM). > > I was very disappointed with the performance compared with a NT 4.0+ IDS > 7.30TC5 on the same machine. Both running on the same hardware/cooked files > conf/database data, NT outperforms linux by far. I am using the default > onconfig, just changed number of buffers. I hope that major changes should > be made to my configuration, so any ideas are welcome. Please help quit > using Micro$oft NT. > > Thanks id advance. > Regards. Diego Mezzera. > > ------=_NextPart_000_0007_01BF5B85.BFC993A0 > Content-Type: application/octet-stream; > name="onconfig" > Content-Transfer-Encoding: quoted-printable > Content-Disposition: attachment; > filename="onconfig" > > #************************************************************************= > **=0A= > #=0A= > # INFORMIX SOFTWARE, INC.=0A= > #=0A= > # Title: onconfig.std=0A= > # Description: Informix Dynamic Server Configuration Parameters=0A= > #=0A= > #************************************************************************= > **=0A= > =0A= > # Root Dbspace Configuration=0A= > =0A= > ROOTNAME rootdbs # Root dbspace name=0A= > ROOTPATH /info1/rootdbs.000 # Path for device containing root = > dbspace=0A= > ROOTOFFSET 0 # Offset of root dbspace into device = > (Kbytes)=0A= > ROOTSIZE 50000 # Size of root dbspace (Kbytes)=0A= > =0A=> # Disk Mirroring Configuration Parameters=0A= > =0A= > MIRROR 0 # Mirroring flag (Yes =3D 1, No =3D 0)=0A= > MIRRORPATH # Path for device containing mirrored = > root=0A= > MIRROROFFSET 0 # Offset into mirrored device (Kbytes)=0A= > =0A=> # Physical Log Configuration=0A= > =0A= > PHYSDBS rootdbs # Location (dbspace) of physical log=0A= > PHYSFILE 1000 # Physical log file size (Kbytes)=0A= > =0A=> # Logical Log Configuration=0A= > =0A= > LOGFILES 6 # Number of logical log files=0A= > LOGSIZE 500 # Logical log size (Kbytes)=0A= > =0A= > # Diagnostics=0A= > =0A=> MSGPATH /opt/informix/online.log # System message log file path=0A= > CONSOLE /dev/null # System console message path=0A= > ALARMPROGRAM /opt/informix/etc/log_full.sh # Alarm program path=0A= > SYSALARMPROGRAM /opt/informix/etc/evidence.sh # System Alarm program path=0A= > TBLSPACE_STATS 1 =0A= > =0A=> # System Archive Tape Device=0A= > =0A= > TAPEDEV /dev/null # Tape device path =0A= > TAPEBLK 16 # Tape block size (Kbytes)=0A= > TAPESIZE 10240 # Maximum amount of data to put on tape = > (Kbytes)=0A= > =0A= > # Log Archive Tape Device=0A= > =0A= > LTAPEDEV /dev/null # Log tape device path=0A= > LTAPEBLK 16 # Log tape block size (Kbytes)=0A= > LTAPESIZE 10240 # Max amount of data to put on log tape = > (Kbytes)=0A= > =0A= > # Optical=0A= > =0A=> STAGEBLOB # Informix Dynamic Server/Optical = > staging area=0A= > =0A= > # System Configuration=0A= > =0A= > SERVERNUM 0 # Unique id corresponding to a Dynamic = > Server instance=0A= > DBSERVERNAME ol_linuxshm # Name of default database server=0A= > DBSERVERALIASES ol_linux # List of alternate dbservernames=0A= > NETTYPE ipcshm,1,10,CPU # Configure poll thread(s) for nettype=0A= > NETTYPE soctcp,1,10,NET # Configure poll thread(s) for nettype=0A= > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in = > distributed env.=0A= > RESIDENT 0 # Forced residency flag (Yes =3D 1, No = > =3D 0)=0A= > =0A= > MULTIPROCESSOR 0 # 0 for single-processor, 1 for = > multi-processor=0A= > NUMCPUVPS 1 # Number of user (cpu) vps=0A= > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps = > to one=0A= > =0A=> #NOAGE 0 # Process aging=0A= > #AFF_SPROC 0 # Affinity start processor=0A= > #AFF_NPROCS 0 # Affinity number of processors=0A= > =0A= > # Shared Memory Parameters=0A= > =0A= > LOCKS 2000 # Maximum number of locks=0A= > BUFFERS 10000 # Maximum number of shared buffers=0A= > NUMAIOVPS # Number of IO vps=0A= > PHYSBUFF 32 # Physical log buffer size (Kbytes)=0A= > LOGBUFF 32 # Logical log buffer size (Kbytes)=0A=> LOGSMAX 6 # Maximum number of logical log files=0A= > CLEANERS 1 # Number of buffer cleaner processes=0A= > SHMBASE 0x10000000 # Shared memory base address=0A= > SHMVIRTSIZE 8000 # initial virtual shared memory segment = > size=0A= > SHMADD 8192 # Size of new shared memory segments = > (Kbytes)=0A= > SHMTOTAL 0 # Total shared memory (Kbytes). = > 0=3D>unlimited=0A= > CKPTINTVL 300 # Check point interval (in sec)=0A= > LRUS 4 # Number of LRU queues=0A= > LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit=0A= > LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit=0A= > LTXHWM 50 # Long transaction high water mark = > percentage=0A= > LTXEHWM 60 # Long transaction high water mark = > (exclusive)=0A= > TXTIMEOUT 0x12c # Transaction timeout (in sec)=0A= > STACKSIZE 32 # Stack size (Kbytes)=0A= > =0A= > # System Page Size=0A=> # BUFFSIZE - Dynamic Server no longer supports this configuration = > parameter.=0A= > # To determine the page size used by Dynamic Server on your = > platform=0A= > # see the last line of output from the command, 'onstat -b'.=0A= > =0A= > =0A= > # Recovery Variables=0A= > # OFF_RECVRY_THREADS:=0A= > # Number of parallel worker threads during fast recovery or an offline = > restore.=0A= > # ON_RECVRY_THREADS:=0A= > # Number of parallel worker threads during an online restore.=0A= > =0A= > OFF_RECVRY_THREADS 10 # Default number of offline worker = > threads=0A= > ON_RECVRY_THREADS 1 # Default number of online worker = > threads=0A= > =0A=> # Data Replication Variables=0A= > # DRAUTO: 0 manual, 1 retain type, 2 reverse type=0A= > DRAUTO 0 # DR automatic