NETTYPE

Hello everybody. We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next values in ONCONFIG: NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) for nettype RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 100000 # Maximum number of locks BUFFERS 53248 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps SHMBASE 0x200000000 # Shared memory base address SHMVIRTSIZE 155648 # initial virtual shared memory segment size SHMADD 20480 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited Now, we'll have more users through soctcp (>400) than ipcshm (<30) connections. How can i set the values of NETTYPE? Thanks for helping me Pablo F. Herrero GIJON (SPAIN) Sent via Deja.com http://www.deja.com/ Before you buy.

In article <61CEA8293505D211A0E90000F87AAD7D2E02EE@srrcex1.srrpa.es>, =?iso-8859-1?Q?Pablo_Herrero_Fern=E1ndez?= <PabloF.Herrero@srrpa.es> wrote: > Hello everybody. > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next > values in ONCONFIG: > > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype > NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) fornettype > 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 cpuvps to > one > > NOAGE 0 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > LOCKS 100000 # Maximum number of locks > BUFFERS 53248 # Maximum number of shared buffers > NUMAIOVPS 2 # Number of IO vps > SHMBASE 0x200000000 # Shared memory base address > SHMVIRTSIZE 155648 # initial virtual shared memorysegment size > SHMADD 20480 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited> > Now, we'll have more users through soctcp (>400) than ipcshm (<30) > connections. How can i set the values of NETTYPE? > This is what I would do to start... NETTYPE soctcp,4,200,CPU NETTYPE ipcshm,1,50,NET This will allow up to 800 users over tcp, and 50 via shared memory, using CPU class VPs for the tcp connections. However, (this is for you, Obnoxio), some people disagree with me on the use of CPU VPs for tcp connections. What I gave you is the recommendataion that I got from an Informix Performance Tuning class, but you might want to switch them around and see if there's a difference for you. > Thanks for helping me > Pablo F. Herrero > GIJON (SPAIN) > > Sent via Deja.com http://www.deja.com/ > Before you buy. > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Pablo Herrero Fernández wrote: > > Hello everybody. > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next > values in ONCONFIG: > > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype Make the above: NETTYPE soctcp,2,250,NET # 2 listeners w/ 250 connections each > NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) for nettype > 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 0 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > LOCKS 100000 # Maximum number of locks > BUFFERS 53248 # Maximum number of shared buffers > NUMAIOVPS 2 # Number of IO vps > SHMBASE 0x200000000 # Shared memory base address > SHMVIRTSIZE 155648 # initial virtual shared memory segment size > SHMADD 20480 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited> > Now, we'll have more users through soctcp (>400) than ipcshm (<30) > connections. How can i set the values of NETTYPE? Art S. Kagel

mars1972@my-deja.com wrote: > > In article <61CEA8293505D211A0E90000F87AAD7D2E02EE@srrcex1.srrpa.es>, > =?iso-8859-1?Q?Pablo_Herrero_Fern=E1ndez?= <PabloF.Herrero@srrpa.es> > wrote: > > Hello everybody. > > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the > next > > values in ONCONFIG: > > > > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype > > NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) for> nettype > > 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 0 # Process aging > > AFF_SPROC 0 # Affinity start processor > > AFF_NPROCS 0 # Affinity number of processors> > > > # Shared Memory Parameters > > > > LOCKS 100000 # Maximum number of locks > > BUFFERS 53248 # Maximum number of shared buffers > > NUMAIOVPS 2 # Number of IO vps > > SHMBASE 0x200000000 # Shared memory base address > > SHMVIRTSIZE 155648 # initial virtual shared memory> segment size > > SHMADD 20480 # Size of new shared memory segments > > (Kbytes) > > SHMTOTAL 0 # Total shared memory (Kbytes). > 0=>unlimited> > > > Now, we'll have more users through soctcp (>400) than ipcshm (<30) > > connections. How can i set the values of NETTYPE? > > > This is what I would do to start... > > NETTYPE soctcp,4,200,CPU Problem: Pablo only has 3CPU VPs so the above will allocate at least one NET VP to handle the fourth listener. > NETTYPE ipcshm,1,50,NET> > This will allow up to 800 users over tcp, and 50 via shared memory, > using CPU class VPs for the tcp connections. > > However, (this is for you, Obnoxio), some people disagree with me on the > use of CPU VPs for tcp connections. What I gave you is the > recommendataion that I got from an Informix Performance Tuning class, > but you might want to switch them around and see if there's a difference > for you. I'm the big disagree-er on this issue (I guess on most I'm just contrary :-). If you put sharec memory listeners in NET VPs they will have to poll, spin the CPUs, and flood the OS with system calls to perform their task. If you put TCP listeners in the CPU VPs they also will have to poll the socket so they will also hog the CPU. However, if you place NET listeners in NET VPs they can block on a select() system call until there is a connect request or data block and then wake and process the new connection or request. If you place the shared memory connections in CPU VPs (and use all 3 CPU VPs) then since the CPU VPs cannot block, since they have work to do, they will periodically poll the shared memory blocks for connections and new data and will be able to handle the requests quickly. If all the CPU VPs are listening then requests do not have to wait for CPU VP#1, which is the busiest always, to become free to schedule the new request. So with my prior post the NETTYPES become: NETTYPE soctcp,2,250,NET # 2 x 250 = 500 connections supported. NETTYPE ipcshm,3,50,CPU # 50 connections is the default so might as well. Art S. Kagel

Pablo, By a coincident I saw you message and basically I have a problem with your setting ;-( You have a platform with two CPUs and you are creating three CPUvps and one NETvp. A NETvp needs to stay running on the CPU as long as possible (it will need to poll the net ALL the time) You also have three CPUvps that will be fighting for the CPUs with the NETvp. This will create too much system overhead and waist of resources. I am sure that you will get better performance if you only configure two CPUvps and change NUMCPUVPS 2 (You should never have more CPUvps that processors) and change NETTYPE soctcp,1,50,NET to use inline poll threads NETTYPE soctcp,1,400,CPU (You can add another poll thread if you feel the system respons is too slow) -- Gerson Finlev, Performance Engineering, i.informix Informix Software, Inc., Phone : 650/926-6431 4100 Bohannon Drive, Menlo Park, CA 94025 Pablo Herrero Fernández wrote: > Hello everybody. > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next > values in ONCONFIG: > > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype > NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) for nettype > 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 0 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > LOCKS 100000 # Maximum number of locks > BUFFERS 53248 # Maximum number of shared buffers > NUMAIOVPS 2 # Number of IO vps > SHMBASE 0x200000000 # Shared memory base address > SHMVIRTSIZE 155648 # initial virtual shared memory segment size > SHMADD 20480 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited> > Now, we'll have more users through soctcp (>400) than ipcshm (<30) > connections. How can i set the values of NETTYPE? > > Thanks for helping me > Pablo F. Herrero > GIJON (SPAIN) > > Sent via Deja.com http://www.deja.com/ > Before you buy.