Informix

 View Only
  • 1.  Spin locks

    Posted Fri January 08, 2021 06:59 AM
    I am observing following spin locks

    Top spi where Num Loops are high


    Num Waits Num Loops Avg Loop/Wait Name

    206 8530238207 41408923.33 mtcb mutex_list_lock

    1741 242603370 139347.14 fast mutex, lockhash[705]

    29975 216380509 7218.7 class cl_lock, class = 0

    151370 172400295 1138.93 mutex lock, name = INH list

    708 64244429 90740.72 mutex lock, name = log

    456 57240374 125527.14 fast mutex, lockhash[713]

    5191 24317182 4684.49 pool po_lock, name = global

    1768 18331879 10368.71 mutex lock, name = hdr_AckQ

    7312 11225103 1535.16 mutex lock, name = RA_Q_List

    11223 9794411 872.71 fast mutex, 0:bf[1024] 0x100004 0x6a9cc0800

    5269 7072307 1342.25 shmcb sh_lock

    29 6582337 226977.14 mtcb tcb_queue_lock

    7923 3234747 408.27 mutex lock, name = INH list


    Top spi where Avg Loop/Wait are high


    Num Waits Num Loops Avg Loop/Wait Name

    206 8530238207 41408923.33 mtcb mutex_list_lock

    1 230001 230001 tcb lock, tid = 1617563

    1 230001 230001 tcb lock, tid = 1986214

    1 230001 230001 tcb lock, tid = 1987687

    1 230001 230001 fast mutex, 1:bhash[1085686]

    1 230001 230001 fast mutex, gfile gfd 193 ioq_lock

    29 6582337 226977.14 mtcb tcb_queue_lock

    1 209699 209699 tcb lock, tid = 1293

    1741 242603370 139347.14 fast mutex, lockhash[705]

    456 57240374 125527.14 fast mutex, lockhash[713]

    1 108491 108491 tcb lock, tid = 1984622

    9 920855 102317.22 mutex lock, name = ddh chain 66

    13 1275626 98125.08 fast mutex, 1:bf[1024] 0xf00013 0x8dbdf9000

    22 2015707 91623.05 fast mutex, 1:bf[1024] 0xf0001b 0x79fa91000

    708 64244429 90740.72 mutex lock, name = log

    3 232314 77438 tcb lock, tid = 1984772

    7 508710 72672.86 mutex lock, name = sapi.SYS

    2 125511 62755.5 tcb lock, tid = 1986623

    4 202322 50580.5 fast mutex, 1:bf[1024] 0xf00017 0x7effe7000

    2 96382 48191 tcb lock, tid = 520731

    5 230875 46175 mutex lock, name = pt_2034be

    33 1522983 46151 mutex lock, name = ddh chain 306

    1 42622 42622 tcb lock, tid = 1982447

    19 779106 41005.58 mutex lock, name = centry -142795858

    39 1445660 37068.21 mutex lock, name = ddh chain 377

    1 36329 36329 mutex lock, name = netnorm

    7 232499 33214.14 mutex lock, name = ddh chain 150

    2 56927 28463.5 tcb lock, tid = 1984520

    4 111357 27839.25 fast mutex, 0:bhash[417187]

    12 322959 26913.25 fast mutex, 1:bf[1024] 0xf00011 0x7d9546000

    7 187257 26751 tcb lock, tid = 1635

    54 1360596 25196.22 mutex lock, name = ddh chain 16

    1 24100 24100 mutex lock, name = netnorm

    53 1241493 23424.4 mutex lock, name = ddh chain 191

    10 231904 23190.4 mutex lock, name = smx free 4

    4 92510 23127.5 fast mutex, 1:bf[1024] 0xf00014 0x8dbf46000

    1 20388 20388 tcb lock, tid = 1984128

    9 178579 19842.11 fast mutex, 1:bf[1024] 0xf00011 0x7bff3b000

    110 2076765 18879.68 mutex lock, name = ddh chain 263

    3 54764 18254.67 lockfr2

    1 17647 17647 fast mutex, 1:bhash[2873136]

    4 70401 17600.25 tcb lock, tid = 1439

    7 122873 17553.29 fast mutex, 1:bf[1024] 0xf0001c 0x79fa9b000

    28 471668 16845.29 mutex lock, name = pt_f00025

    6 99858 16643 fast mutex, 1:bhash[2707146]

    1 16432 16432 fast mutex, 1:bhash[2932658]

    1 16404 16404 tcb lock, tid = 1987368

    1 16016 16016 fast mutex, 0:bf[1024] 0x201787 0x707677000

    50 798928 15978.56 fast mutex, 0:bf[1024] 0x2027c0 0x6a18d5000

    1 14366 14366 tcb lock, tid = 1986980

    14 200024 14287.43 fast mutex, 0:bf[1024] 0x2027d1 0x6ea44f000

    1 14203 14203 fast mutex, 1:bhash[319800]

    4 53812 13453 tcb lock, tid = 1984244

    1 13046 13046 tcb lock, tid = 517037

    18 232104 12894.67 mutex lock, name = netfree

    9 113765 12640.56 tcb lock, tid = 1987263

    99 1207692 12198.91 mutex lock, name = ddh chain 3

    18 216112 12006.22 mutex lock, name = centry 909291775

    1 10494 10494 fast mutex, 1:bf[1024] 0xf0000e 0x96fb2d000

    1768 18331879 10368.71 mutex lock, name = hdr_AckQ

    1 10329 10329 tcb lock, tid = 1986526

    3 30911 10303.67 tcb lock, tid = 1987656

    2 20192 10096 tcb lock, tid = 1986786

    1 10002 10002 tcb lock, tid = 1987685



    ------------------------------
    Khurram Shahzad
    ------------------------------

    #Informix


  • 2.  RE: Spin locks

    IBM Champion
    Posted Tue January 12, 2021 07:46 AM
    I'd say almost all of these have a non-significant 'Num Waits' number, so these spin locks had not been waited for very frequently, and maybe even fewer of these waits were very expensive. Moreove we don't learn over which period of time those counts accumulated.

    Not seeing a real reason for worries from this alone.

    HTH,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------