CPU vps & affinity parms

Posted in 2000

Summary

A poster with a 2-CPU Alpha 4100 running Informix 7.23.FC3 asked for MULTIPROCESSOR, NUMCPUVPS, SINGLE_CPU_VP, NOAGE, AFF_SPROC and AFF_NPROCS settings. Marat suggested MULTIPROCESSOR 1, SINGLE_CPU_VP 0, NOAGE 1 if supported, NUMCPUVPS 2 (or possibly 1), and example affinity values such as AFF_SPROC 1, AFF_NPROCS 1. No feedback followed.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

remove (_at_) to reply — Thu, 11 May 2000 14:34:11 +0200 — source: Informix-list mailing list archive (1991-1998)

What are recomendations for Informix 7.x params: MULTIPROCESSOR NUMCPUVPS SINGLE_CPU_VP NOAGE AFF_SPROC AFF_NPROCS Machine has 2 CPU.

↪ replying to remove (_at_) to reply

Marat — Thu, 11 May 2000 19:47:14 +0400 — source: Informix-list mailing list archive (1991-1998)

"remove (_at_) to reply" wrote: > What are recomendations for Informix 7.x params: > > MULTIPROCESSOR MULTIPROCESSOR 1 (if server dedicated for DB) > > NUMCPUVPS NUMCPUVPS 2 (if server dedicated for DB) > > SINGLE_CPU_VP SINGLE_CPU_VP 0 > > NOAGE NOAGE 1 (if supported - see $INFORMIXDIR/release/en_us/0333/IDS_7.x) > > AFF_SPROC no any observation about this if #HWCPU=2 > AFF_NPROCS no any observation about this if #HWCPU=2 > possible combinations different from std (if first CPU id from mpstat is 0) AFF_SPROC 0 AFF_NPROCS 2 AFF_SPROC 1 AFF_NPROCS 1 AFF_SPROC 0 AFF_NPROCS 1 > > Machine has 2 CPU.

↪ replying to remove (_at_) to reply

remove (_at_) to reply — Fri, 12 May 2000 08:53:58 +0200 — source: Informix-list mailing list archive (1991-1998)

On Thu, 11 May 2000 14:34:11 +0200, "remove (_at_) to reply" <mips_at_@zg.tel.hr> wrote: >What are recomendations for Informix 7.x params: > >MULTIPROCESSOR >NUMCPUVPS >SINGLE_CPU_VP >NOAGE >AFF_SPROC >AFF_NPROCS> >Machine has 2 CPU. It is DB and application server. Alpha 4100, 2 CPU, 2GB RAM, True 64 Unix ver 4.0F Informix 7.23.FC3

↪ replying to remove (_at_) to reply

remove (_at_) to reply — Fri, 12 May 2000 08:54:13 +0200 — source: Informix-list mailing list archive (1991-1998)

↪ replying to remove (_at_) to reply

Marat — Fri, 12 May 2000 11:45:16 +0400 — source: Informix-list mailing list archive (1991-1998)

MULTIPROCESSOR 1 (if server dedicated for DB) NUMCPUVPS 2 (there are recommendations NUMCPUVPS=#HWCPUS if #HWCPUS <=3) IMHO NUMCPUVPS 1 maybe would be better cause 2 CPU isn't 4,8 and more - overhead may be greater then benefit SINGLE_CPU_VP 0 - depends on NUMCPUVPS NOAGE 1 (if supported - see $INFORMIXDIR/release/en_us/0333/IDS_7.x) AFF_SPROC 1 AFF_NPROCS 1 "remove (_at_) to reply" wrote: > On Thu, 11 May 2000 14:34:11 +0200, "remove (_at_) to reply" > <mips_at_@zg.tel.hr> wrote: > > >What are recomendations for Informix 7.x params: > > > >MULTIPROCESSOR > >NUMCPUVPS > >SINGLE_CPU_VP > >NOAGE > >AFF_SPROC > >AFF_NPROCS> > > >Machine has 2 CPU. > > It is DB and application server. > > Alpha 4100, 2 CPU, 2GB RAM, True 64 Unix ver 4.0F > > Informix 7.23.FC3