Re: spin locks

Added to FAQ. Regards, David. > On 22 September 2013 at 02:20 Art Kagel <art.kagel@gmail.com> 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. >