IDS Forum

Re: spin locks

Posted By: Art Kagel
Date: Monday, 23 September 2013, at 12:04 p.m.

In Response To: Re: spin locks (Hrvoje Zokovic)

That's true. I missed the "IE" in the version string.

Art

Art S. Kagel, Principal Consultant

Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Sep 23, 2013 at 3:02 AM, Hrvoje Zokovic <hzokovic.iiug@gmail.com>wrote:

> According to 12.10.TC1IE i think this is innovator-C edition and you can
> not use CPU VP memory
> cache on this edition (it is Enterprise/Ultimate only feature)
> HTH
> Hrvoje
>
> On 22.9.2013. 3:20, Art Kagel wrote:
> > IB that is the memory pool latch. You can probably reduce the activity on
> > it by enabling VP_MEMORY_CACHE_KB so that each CPU VP holds on to some of
> > the memory from the central pool and so has to interact with the pool
> latch
> > less frequently.
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> >
> > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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, Sep 20, 2013 at 4:56 PM, BillHatVerizon
> <garage_dba@verizon.net>wrote:
> >
> >> This is the output of onstat g spi .
> >> What is po_lock below?
> >> Do the numbers look high or is it not possible to answer without more
> info
> >> ?
> >> This is on Windows server 2008 R2 SP1.
> >>
> >> IBM Informix Dynamic Server Version 12.10.TC1IE -- On-Line -- Up
> 09:04:41
> >> --
> >> 733952 Kbytes
> >>
> >> Spin locks with waits:
> >> Num Waits Num Loops Avg Loop/Wait Name
> >> 1 88 88.00 mutex lock, name = AIOreq
> >> 2 31 15.50 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 121 121.00 mutex lock, name = AIOreq
> >> 1 102 102.00 mutex lock, name = AIOreq
> >> 1 38 38.00 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 110 110.00 mutex lock, name = AIOreq
> >> 1 155 155.00 mutex lock, name = AIOreq
> >> 1 203 203.00 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 28 28.00 mutex lock, name = AIOreq
> >> 2 102 51.00 mutex lock, name = AIOreq
> >> 1 14 14.00 mutex lock, name = AIOreq
> >> 1 80 80.00 mutex lock, name = AIOreq
> >> 2 63 31.50 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 68 68.00 mutex lock, name = AIOreq
> >> 1 116 116.00 mutex lock, name = AIOreq
> >> 1 19 19.00 mutex lock, name = AIOreq
> >> 1 160 160.00 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 1 170 170.00 mutex lock, name = AIOreq
> >> 1 48 48.00 mutex lock, name = AIOreq
> >> 1 24 24.00 mutex lock, name = AIOreq
> >> 1 68 68.00 mutex lock, name = AIOreq
> >> 2 134 67.00 mutex lock, name = AIOreq
> >> 2 183 91.50 mutex lock, name = AIOreq
> >> 1 49 49.00 mutex lock, name = AIOreq
> >> 3 284 94.67 mutex lock, name = AIOreq
> >> 1 6 6.00 mutex lock, name = AIOreq
> >> 1 58 58.00 mutex lock, name = AIOreq
> >> 1 1 1.00 mutex lock, name = AIOreq
> >> 2 135 67.50 mutex lock, name = AIOreq
> >> 2 49 24.50 mutex lock, name = AIOreq
> >> 1 61 61.00 mutex lock, name = AIOreq
> >> 1 10 10.00 mutex lock, name = AIOreq
> >> 4 759 189.75 shmcb sh_lock
> >> 118 60205 510.21 pool po_lock, name = global
> >>
> >>
> >>
> >>
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> > --001a113366bc05dd7b04e6eeb4df
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c36cde42dc0e04e70f10c2

Messages In This Thread

• spin locks
  BillHatVerizon -- Friday, 20 September 2013, at 4:56 p.m.
  • Re: spin locks
    Marco Greco -- Saturday, 21 September 2013, at 6:00 a.m.
    • Re: spin locks
      david@smooth1.co.uk -- Thursday, 28 August 2014, at 6:20 a.m.
  • Re: spin locks
    Art Kagel -- Saturday, 21 September 2013, at 9:20 p.m.
    • Re: spin locks
      Hrvoje Zokovic -- Monday, 23 September 2013, at 3:02 a.m.
      • Re: spin locks
        Art Kagel -- Monday, 23 September 2013, at 12:04 p.m.
        • Re: spin locks
          John Miller iii -- Monday, 23 September 2013, at 1:47 p.m.
          • Re: spin locks
            david@smooth1.co.uk -- Monday, 23 September 2013, at 3:44 p.m.
            • Re: spin locks
              John Miller iii -- Monday, 23 September 2013, at 5:52 p.m.
              • Re: spin locks
                david@smooth1.co.uk -- Thursday, 28 August 2014, at 6:22 a.m.
            • Re: spin locks
              Art Kagel -- Monday, 23 September 2013, at 9:23 p.m.
          • Re: spin locks
            david@smooth1.co.uk -- Thursday, 28 August 2014, at 6:21 a.m.
        • Re: spin locks
          BillHatVerizon -- Monday, 23 September 2013, at 5:50 p.m.
    • Re: spin locks
      david@smooth1.co.uk -- Thursday, 28 August 2014, at 6:21 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.