Oninit cdi / Archive
Talk to an expert →

Linux Processor x Informix 11.5FC5WE

Posted in 2015

Topics: Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues

André Luiz Rufino — — source: IIUG Forums & Mailing Lists

Good morning everyone. I have a IDS 11.5FC5WE installed on Red Hat 6 Linux. I don't want to use AFFINITY resources and I dont know how to avoid. My VPCLASS ONCONFIG parameters MULTIPROCESSOR 1 VPCLASS cpu,num=4,noage,aff=0 VP_MEMORY_CACHE_KB 0 SINGLE_CPU_VP 0 Linux commands output [root@srvgbdb001 ~]# lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 120 On-line CPU(s) list: 0-119 Thread(s) per core: 2 Core(s) per socket: 15 Socket(s): 4 NUMA node(s): 4 Vendor ID: GenuineIntel CPU family: 6 Model: 62 Stepping: 7 CPU MHz: 2499.974 BogoMIPS: 4999.28 Virtualization: VT-x L1d cache: 32K L1i cache: 32K L2 cache: 256K L3 cache: 38400K NUMA node0 CPU(s): 0,4,8,12,16,20,24,28,32,36,40,44,48,52,56,60,64,68,72,76,80,84,88,92,96,100,104, 108,112,116 NUMA node1 CPU(s): 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61,65,69,73,77,81,85,89,93,97,101,105, 109,113,117 NUMA node2 CPU(s): 2,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,66,70,74,78,82,86,90,94,98,102,106 ,110,114,118 NUMA node3 CPU(s): 3,7,11,15,19,23,27,31,35,39,43,47,51,55,59,63,67,71,75,79,83,87,91,95,99,103,107 ,111,115,119 [root@srvgbdb001 ~]# dmidecode -t4 | grep 'Core Count' Core Count: 15 Core Count: 15 Core Count: 15 Core Count: 15 [root@srvgbdb001 ~]# dmidecode -t 4 | grep CPU Socket Designation: CPU1 Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz Socket Designation: CPU2 Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz Socket Designation: CPU3 Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz Socket Designation: CPU4 Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz [root@srvgbdb001 ~]# egrep 'siblings|cpu cores' /proc/cpuinfo | head -2 siblings : 30 cpu cores : 15 [root@srvgbdb001 ~]# cat /proc/cpuinfo | grep "physical id" | sort | uniq | wc -l 4 I have two questions: 1 - How many CPU do I have to consider to set the cpu VPCLASS ? 4 ? 16 ? 120 ? 2 - How can I disable AFFINITY PROCS on IDS 11.5 ? Thansk a lot Amndré Luiz Rufino

↪ replying to André Luiz Rufino
Art Kagel — — source: IIUG Forums & Mailing Lists

Affinity is OFF by default, the aff= clause in your VPCLASS entry is turning it on and assigning all VPs to processor core #0. Just remove that entry. As far as how many VPs to use, my testing over the years shows that Informix can take advantage of about 450-500MHZ of processor cycles. That means that on a 2.50GHZ processor you can run between four and five CPU VPs per core if you need that level of parallelism. DO NOT count the processor threads as cores, so your XEON 4880 processors each have 15 physical cores and you have four processor chips installed for a total of 60 cores. So, if you want to get aggressive and need to be able to handle up to 300 concurrently running query sessions, then you could create 300 CPU VPs. If you want to be most conservative and run one CPU VP per core then up to 60 CPU VPs would be the max. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 27, 2015 at 7:18 AM, André Luiz Rufino <andre_rufino@msn.com> wrote: > Good morning everyone. > > I have a IDS 11.5FC5WE installed on Red Hat 6 Linux. I don't want to use > AFFINITY resources and I dont know how to avoid. > > My VPCLASS ONCONFIG parameters > MULTIPROCESSOR 1 > VPCLASS cpu,num=4,noage,aff=0 > VP_MEMORY_CACHE_KB 0 > SINGLE_CPU_VP 0> > Linux commands output > > [root@srvgbdb001 ~]# lscpu > Architecture: x86_64 > CPU op-mode(s): 32-bit, 64-bit > Byte Order: Little Endian > CPU(s): 120 > On-line CPU(s) list: 0-119 > Thread(s) per core: 2 > Core(s) per socket: 15 > Socket(s): 4 > NUMA node(s): 4 > Vendor ID: GenuineIntel > CPU family: 6 > Model: 62 > Stepping: 7 > CPU MHz: 2499.974 > BogoMIPS: 4999.28 > Virtualization: VT-x > L1d cache: 32K > L1i cache: 32K > L2 cache: 256K > L3 cache: 38400K > NUMA node0 CPU(s): > > 0,4,8,12,16,20,24,28,32,36,40,44,48,52,56,60,64,68,72,76,80,84,88,92,96,100,104, 108,112,116 > NUMA node1 CPU(s): > > 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61,65,69,73,77,81,85,89,93,97,101,105, 109,113,117 > NUMA node2 CPU(s): > > 2,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,66,70,74,78,82,86,90,94,98,102,106 ,110,114,118 > NUMA node3 CPU(s): > > 3,7,11,15,19,23,27,31,35,39,43,47,51,55,59,63,67,71,75,79,83,87,91,95,99,103,107 ,111,115,119 > [root@srvgbdb001 ~]# dmidecode -t4 | grep 'Core Count' > Core Count: 15 > Core Count: 15 > Core Count: 15 > Core Count: 15 > [root@srvgbdb001 ~]# dmidecode -t 4 | grep CPU > Socket Designation: CPU1 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > Socket Designation: CPU2 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > Socket Designation: CPU3 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > Socket Designation: CPU4 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > [root@srvgbdb001 ~]# egrep 'siblings|cpu cores' /proc/cpuinfo | head -2 > siblings : 30 > cpu cores : 15 > [root@srvgbdb001 ~]# cat /proc/cpuinfo | grep "physical id" | sort | uniq > | wc > -l > 4 > > I have two questions: > > 1 - How many CPU do I have to consider to set the cpu VPCLASS ? 4 ? 16 ? > 120 ? > > 2 - How can I disable AFFINITY PROCS on IDS 11.5 ? > > Thansk a lot > > Amndré Luiz Rufino > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c335f686588b0510113a46

↪ replying to André Luiz Rufino
Marco Greco — — source: IIUG Forums & Mailing Lists

On 27/02/15 12:18, André Luiz Rufino wrote: > Good morning everyone. > > I have a IDS 11.5FC5WE installed on Red Hat 6 Linux. I don't want to use > AFFINITY resources and I dont know how to avoid. > > My VPCLASS ONCONFIG parameters > MULTIPROCESSOR 1 > VPCLASS cpu,num=4,noage,aff=0 > VP_MEMORY_CACHE_KB 0 > SINGLE_CPU_VP 0> > Linux commands output > > [root@srvgbdb001 ~]# lscpu > Architecture: x86_64 > CPU op-mode(s): 32-bit, 64-bit > Byte Order: Little Endian > CPU(s): 120 > On-line CPU(s) list: 0-119 > Thread(s) per core: 2 > Core(s) per socket: 15 > Socket(s): 4 > NUMA node(s): 4 > Vendor ID: GenuineIntel > CPU family: 6 > Model: 62 > Stepping: 7 > CPU MHz: 2499.974 > BogoMIPS: 4999.28 > Virtualization: VT-x > L1d cache: 32K > L1i cache: 32K > L2 cache: 256K > L3 cache: 38400K > NUMA node0 CPU(s): > 0,4,8,12,16,20,24,28,32,36,40,44,48,52,56,60,64,68,72,76,80,84,88,92,96,100,104, 108,112,116 > NUMA node1 CPU(s): > 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61,65,69,73,77,81,85,89,93,97,101,105, 109,113,117 > NUMA node2 CPU(s): > 2,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,66,70,74,78,82,86,90,94,98,102,106 ,110,114,118 > NUMA node3 CPU(s): > 3,7,11,15,19,23,27,31,35,39,43,47,51,55,59,63,67,71,75,79,83,87,91,95,99,103,107 ,111,115,119 > [root@srvgbdb001 ~]# dmidecode -t4 | grep 'Core Count' > Core Count: 15 > Core Count: 15 > Core Count: 15 > Core Count: 15 > [root@srvgbdb001 ~]# dmidecode -t 4 | grep CPU > Socket Designation: CPU1 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > Socket Designation: CPU2 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > Socket Designation: CPU3 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > Socket Designation: CPU4 > Version: Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz > [root@srvgbdb001 ~]# egrep 'siblings|cpu cores' /proc/cpuinfo | head -2 > siblings : 30 > cpu cores : 15 > [root@srvgbdb001 ~]# cat /proc/cpuinfo | grep "physical id" | sort | uniq | wc > -l > 4 > > I have two questions: > > 1 - How many CPU do I have to consider to set the cpu VPCLASS ? 4 ? 16 ? 120 ? > > 2 - How can I disable AFFINITY PROCS on IDS 11.5 ? > > Thansk a lot > > Amndré Luiz Rufino > > I would ditch that 'aff=0' in your VPCLASS cpu, as that affinitizes everything to core 0! Also, make sure you don't have the obsolete AFFINITY parameter in your onconfig. -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Glossary