Physical Processor to Virtual processor mapping.
Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt idl 0 96 0 266 282 180 438 2 20 18 0 989 1 2 0 97 1 11 0 75 185 163 883 20 16 29 0 495 14 4 0 81 2 5 0 40 46 1 930 41 12 23 0 90 19 4 0 77 3 13 0 52 22 1 739 17 14 20 0 478 13 3 0 84 8 82 0 217 10 1 626 6 16 19 0 719 9 3 0 89 9 26 0 165 989 973 400 3 9 24 0 108 6 5 0 89 10 13 0 107 897 893 203 1 7 61 0 264 4 4 0 92 11 18 0 111 7 4 135 1 11 9 0 1060 3 1 0 96 16 107 0 529 46 22 373 1 12 14 0 830 1 4 0 95 17 28 0 360 43 40 305 0 8 12 0 448 0 2 0 98 18 14 0 172 4 1 224 0 8 7 0 233 0 1 0 99 19 20 0 99 106 103 72 0 18 9 0 255 0 1 0 99 Instance 1 CPU Affinity in onconfig VPCLASS CPU,num=9,aff=1-17,noage Instance 2 CPU Affinity in onconfig VPCLASS CPU,num=2,aff=18-19,noage When I run a heavy transaction in Instance 2, I don't see the CPUs 18 and 19 utilized. Most likely it is utilizing the first two CPUs. Sun OS sees the CPUs as (0, 1, 2, 3, 8, 9, 10, 11, 16, 17, 18, 19). I would like to know how an Informix instance sees the CPUs. Does it see it as Sun Os sees or does it see the CPUs as (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11). Previously I had Instance 1 configured as "VPCLASS CPU,num=9,aff=1-11,noage". If anyone could share their insight, it will be deeply appreciated. Thank you, Kannan Thirugnanam Software Architect (941) 378-7213 ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.
OK, here's what I think is happening. You have defined nine (9) CPU VPs and affined them to the 11 CPUs starting with #1, so IDS has affined these VPs to the nine CPUS 1, 2, 3, 8, 9, 10, 11, 16, & 17. CPU #s 18 & 19 are not included because you ONLY configured nine CPU VPs even though 18 & 19 are included in the list of CPUs available for affinity. Beyond that, your heavy hitting query may not be using even all of the nine CPU VPs available. Art S. Kagel On Nov 16, 2007 3:14 PM, Thirugnanam, Kannan <Kannan.Thirugnanam@jtax.com> wrote: > Hello Everyone, > > We had recently retired one of the cluster nodes and are running the two > Informix instances in the same node. We have also added additional CPUs > to this node. > > Solaris version 9 > > IDS version 9.40 FC4 > > mpstat > > CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt > idl > > 0 96 0 266 282 180 438 2 20 18 0 989 1 2 0 > 97 > > 1 11 0 75 185 163 883 20 16 29 0 495 14 4 0 > 81 > > 2 5 0 40 46 1 930 41 12 23 0 90 19 4 0 > 77 > > 3 13 0 52 22 1 739 17 14 20 0 478 13 3 0 > 84 > > 8 82 0 217 10 1 626 6 16 19 0 719 9 3 0 > 89 > > 9 26 0 165 989 973 400 3 9 24 0 108 6 5 0 > 89 > > 10 13 0 107 897 893 203 1 7 61 0 264 4 4 0 > 92 > > 11 18 0 111 7 4 135 1 11 9 0 1060 3 1 0 > 96 > > 16 107 0 529 46 22 373 1 12 14 0 830 1 4 0 > 95 > > 17 28 0 360 43 40 305 0 8 12 0 448 0 2 0 > 98 > > 18 14 0 172 4 1 224 0 8 7 0 233 0 1 0 > 99 > > 19 20 0 99 106 103 72 0 18 9 0 255 0 1 0 > 99 > > Instance 1 CPU Affinity in onconfig > > VPCLASS CPU,num=9,aff=1-17,noage > > Instance 2 CPU Affinity in onconfig > > VPCLASS CPU,num=2,aff=18-19,noage > > When I run a heavy transaction in Instance 2, I don't see the CPUs 18 > and 19 utilized. Most likely it is utilizing the first two CPUs. Sun OS > sees the CPUs as (0, 1, 2, 3, 8, 9, 10, 11, 16, 17, 18, 19). I would > like to know how an Informix instance sees the CPUs. Does it see it as > Sun Os sees or does it see the CPUs as (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, > 10, 11). > > Previously I had Instance 1 configured as "VPCLASS > CPU,num=9,aff=1-11,noage". > > If anyone could share their insight, it will be deeply appreciated. > > Thank you, > > Kannan Thirugnanam > > Software Architect > > (941) 378-7213 > > ***** Jackson Hewitt Email Disclaimer ***** > > The sender believes that this E-mail and any attachments were free of any > virus, worm, > Trojan horse, and/or malicious code when sent. This message and its > attachments could > have been infected during transmission. By reading the message and opening > any > attachments, the recipient accepts full responsibility for taking > protective > and remedial > action about viruses and other defects. The sender's business entity is > not > liable for any > loss or damage arising in any way from this message or its attachments. > > Privileged/Confidential Information may be contained in this message. If > you > are not the > addressee indicated in this message (or responsible for delivery of the > message to such > person), you may not copy or deliver this message to anyone. In such case, > you > should > destroy this message and kindly notify the sender by reply email. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Thanks Art, for the reply. CPUs 18 and 19 were assigned to Instance 2. My heavy hitting queries were run in Instance 2. Instance 1 CPU Affinity in onconfig VPCLASS CPU,num=9,aff=1-17,noage Instance 2 CPU Affinity in onconfig VPCLASS CPU,num=2,aff=18-19,noage My initial VPCLASS assignments were right and I wasn't monitoring the CPU activity correctly using mpstat. I verified the CPU activity by keeping one instance online and using the heavy hitting queries. It worked perfect. Thank you once again for responding and Good Luck in your new job. Kannan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Sunday, November 18, 2007 9:46 AM To: ids@iiug.org Subject: Re: Physical Processor to Virtual processor ma.... [10402] OK, here's what I think is happening. You have defined nine (9) CPU VPs and affined them to the 11 CPUs starting with #1, so IDS has affined these VPs to the nine CPUS 1, 2, 3, 8, 9, 10, 11, 16, & 17. CPU #s 18 & 19 are not included because you ONLY configured nine CPU VPs even though 18 & 19 are included in the list of CPUs available for affinity. Beyond that, your heavy hitting query may not be using even all of the nine CPU VPs available. Art S. Kagel On Nov 16, 2007 3:14 PM, Thirugnanam, Kannan <Kannan.Thirugnanam@jtax.com> wrote: > Hello Everyone, > > We had recently retired one of the cluster nodes and are running the two > Informix instances in the same node. We have also added additional CPUs > to this node. > > Solaris version 9 > > IDS version 9.40 FC4 > > mpstat > > CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt > idl > > 0 96 0 266 282 180 438 2 20 18 0 989 1 2 0 > 97 > > 1 11 0 75 185 163 883 20 16 29 0 495 14 4 0 > 81 > > 2 5 0 40 46 1 930 41 12 23 0 90 19 4 0 > 77 > > 3 13 0 52 22 1 739 17 14 20 0 478 13 3 0 > 84 > > 8 82 0 217 10 1 626 6 16 19 0 719 9 3 0 > 89 > > 9 26 0 165 989 973 400 3 9 24 0 108 6 5 0 > 89 > > 10 13 0 107 897 893 203 1 7 61 0 264 4 4 0 > 92 > > 11 18 0 111 7 4 135 1 11 9 0 1060 3 1 0 > 96 > > 16 107 0 529 46 22 373 1 12 14 0 830 1 4 0 > 95 > > 17 28 0 360 43 40 305 0 8 12 0 448 0 2 0 > 98 > > 18 14 0 172 4 1 224 0 8 7 0 233 0 1 0 > 99 > > 19 20 0 99 106 103 72 0 18 9 0 255 0 1 0 > 99 > > Instance 1 CPU Affinity in onconfig > > VPCLASS CPU,num=9,aff=1-17,noage > > Instance 2 CPU Affinity in onconfig > > VPCLASS CPU,num=2,aff=18-19,noage > > When I run a heavy transaction in Instance 2, I don't see the CPUs 18 > and 19 utilized. Most likely it is utilizing the first two CPUs. Sun OS > sees the CPUs as (0, 1, 2, 3, 8, 9, 10, 11, 16, 17, 18, 19). I would > like to know how an Informix instance sees the CPUs. Does it see it as > Sun Os sees or does it see the CPUs as (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, > 10, 11). > > Previously I had Instance 1 configured as "VPCLASS > CPU,num=9,aff=1-11,noage". > > If anyone could share their insight, it will be deeply appreciated. > > Thank you, > > Kannan Thirugnanam > > Software Architect > > (941) 378-7213 > > ***** Jackson Hewitt Email Disclaimer ***** > > The sender believes that this E-mail and any attachments were free of any > virus, worm, > Trojan horse, and/or malicious code when sent. This message and its > attachments could > have been infected during transmission. By reading the message and opening > any > attachments, the recipient accepts full responsibility for taking > protective > and remedial > action about viruses and other defects. The sender's business entity is > not > liable for any > loss or damage arising in any way from this message or its attachments. > > Privileged/Confidential Information may be contained in this message. If > you > are not the > addressee indicated in this message (or responsible for delivery of the > message to such > person), you may not copy or deliver this message to anyone. In such case, > you > should > destroy this message and kindly notify the sender by reply email. > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.