Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

IFX 14.10xc8 Updatable RSS and CPU Usage

  • 1.  IFX 14.10xc8 Updatable RSS and CPU Usage

    Posted 07/11/22 04:52 AM
    Hello,

    In dev env. i've configured a pimary with 2 rss. there is no user activity and i see a high usage of CPU
    when a do a onstat -z followed by onstat -g smx i've notice a very high number at #scheds

    onstat -z; onstat -g cpu | grep smx

    IBM Informix Dynamic Server Version 14.10.FC8DE -- Updatable (RSS) -- Up 2 days 20:16:17 -- 3778176 Kbytes
    2022-07-11 10:40:18

    33 smxsnd_ifxsrv4 12cpu 07/11 10:40:11 0.0000 0 cond wait smx pipe1
    34 smxrcv_ifxsrv4 1cpu 07/11 10:40:17 0.0000 0 sleeping secs: 10
    35 smxRecvSnd 9cpu 07/11 10:40:18 0.0000 0 sleeping secs: 1
    36 smxsnd_ifxsrv4 11cpu 07/11 10:40:16 0.0000 0 cond wait smx pipe1
    37 smxrcv_ifxsrv4 11cpu 07/11 10:40:17 0.0000 0 sleeping secs: 10
    38 smxRecvSnd 10cpu 07/11 10:40:18 0.0000 0 sleeping secs: 1
    39 smxsnd_ifxsrv4 11cpu 07/11 10:40:01 0.0000 0 cond wait smx pipe1
    40 smxrcv_ifxsrv4 11cpu 07/11 10:40:09 0.0000 0 sleeping secs: 2
    41 smxRecvSnd 9cpu 07/11 10:40:18 0.0000 0 sleeping secs: 1
    42 smxsnd_ifxsrv4 9cpu 07/11 10:40:06 0.0000 0 cond wait smx pipe1
    43 smxrcv_ifxsrv4 8cpu 07/11 10:40:14 0.0000 0 sleeping secs: 7
    44 smxRecvSnd 10cpu 07/11 10:40:18 0.0000 0 sleeping secs: 1

    after 2 secs
    informix@vmwbsifx05:~/tmp$ onstat -g cpu | grep smx
    33 smxsnd_ifxsrv4 12cpu 07/11 10:40:11 0.0000 0 cond wait smx pipe1
    34 smxrcv_ifxsrv4 1cpu 07/11 10:40:17 0.0000 0 sleeping secs: 3
    35 smxRecvSnd 11cpu 07/11 10:40:25 0.0000 7 sleeping secs: 1
    36 smxsnd_ifxsrv4 11cpu 07/11 10:40:16 0.0000 0 cond wait smx pipe1
    37 smxrcv_ifxsrv4 11cpu 07/11 10:40:17 0.0000 0 sleeping secs: 3
    38 smxRecvSnd 1cpu 07/11 10:40:25 0.0000 7 sleeping secs: 1
    39 smxsnd_ifxsrv4 11cpu 07/11 10:40:01 0.0000 0 cond wait smx pipe1
    40 smxrcv_ifxsrv4 11cpu 07/11 10:40:19 0.0000 1 sleeping secs: 5
    41 smxRecvSnd 1cpu 07/11 10:40:25 0.0000 7 sleeping secs: 1
    42 smxsnd_ifxsrv4 9cpu 07/11 10:40:06 0.0000 0 cond wait smx pipe1
    43 smxrcv_ifxsrv4 8cpu 07/11 10:40:24 0.0000 1 sleeping secs: 10
    44 smxRecvSnd 11cpu 07/11 10:40:25 0.0000 7 sleeping secs: 1

    after 2 secs
    informix@vmwbsifx05:~/tmp$ onstat -g cpu | grep smx

    33 smxsnd_ifxsrv4 10cpu 07/11 10:40:29 0.0001 1 cond wait smx pipe1
    34 smxrcv_ifxsrv4 10cpu 07/11 10:40:29 1.0001 7458653 sleeping secs: 10
    35 smxRecvSnd 1cpu 07/11 10:40:30 0.0000 12 sleeping secs: 1
    36 smxsnd_ifxsrv4 11cpu 07/11 10:40:29 0.0000 1 cond wait smx pipe1
    37 smxrcv_ifxsrv4 12cpu 07/11 10:40:29 1.0001 7561578 sleeping secs: 10
    38 smxRecvSnd 12cpu 07/11 10:40:30 0.0000 12 sleeping secs: 1
    39 smxsnd_ifxsrv4 11cpu 07/11 10:40:01 0.0000 0 cond wait smx pipe1
    40 smxrcv_ifxsrv4 12cpu 07/11 10:40:30 0.5119 3733420 running
    41 smxRecvSnd 11cpu 07/11 10:40:30 0.0000 12 sleeping secs: 1
    42 smxsnd_ifxsrv4 9cpu 07/11 10:40:06 0.0000 0 cond wait smx pipe1
    43 smxrcv_ifxsrv4 8cpu 07/11 10:40:24 0.0000 1 sleeping secs: 5
    44 smxRecvSnd 11cpu 07/11 10:40:30 0.0000 12 sleeping secs: 1

    after 5 minutes
    informix@vmwbsifx05:~/tmp$ onstat -g cpu | grep smx
    33 smxsnd_ifxsrv4 9cpu 07/11 10:50:29 0.0019 31 cond wait smx pipe1
    34 smxrcv_ifxsrv4 9cpu 07/11 10:50:29 31.0012 233325363 sleeping secs: 9
    35 smxRecvSnd 9cpu 07/11 10:50:31 0.0018 613 sleeping secs: 1
    36 smxsnd_ifxsrv4 8cpu 07/11 10:50:29 0.0018 32 cond wait smx pipe1
    37 smxrcv_ifxsrv4 12cpu 07/11 10:50:29 31.0048 232623631 sleeping secs: 9
    38 smxRecvSnd 11cpu 07/11 10:50:31 0.0017 613 sleeping secs: 1
    39 smxsnd_ifxsrv4 10cpu 07/11 10:50:31 0.0019 30 cond wait smx pipe1
    40 smxrcv_ifxsrv4 11cpu 07/11 10:50:31 30.0033 223762497 sleeping secs: 11
    41 smxRecvSnd 11cpu 07/11 10:50:31 0.0017 613 sleeping secs: 1
    42 smxsnd_ifxsrv4 8cpu 07/11 10:50:11 0.0017 30 cond wait smx pipe1
    43 smxrcv_ifxsrv4 8cpu 07/11 10:50:24 30.0033 224640892 sleeping secs: 4
    44 smxRecvSnd 11cpu 07/11 10:50:31 0.0029 613 sleeping secs: 1


    on the primary server all seems ok :

    89 smxrcv ifxsrv5 1cpu 07/11 10:49:01 0.0122 402 sleeping secs: 9
    90 smxsnd_ifxsrv5 8cpu 07/08 14:24:23 0.0000 0 cond wait smx pipe1
    91 smxRecvSnd 12cpu 07/11 10:49:03 0.0101 1804 sleeping secs: 1
    92 smxrcv ifxsrv5 12cpu 07/11 10:49:00 0.0099 397 sleeping secs: 8
    93 smxsnd_ifxsrv5 9cpu 07/11 08:07:30 0.0000 0 cond wait smx pipe1
    94 smxRecvSnd 12cpu 07/11 10:49:03 0.0074 1801 sleeping secs: 1
    95 smxrcv ifxsrv5 12cpu 07/11 10:49:00 0.0108 400 sleeping secs: 8
    96 smxsnd_ifxsrv5 8cpu 07/08 14:24:31 0.0000 0 cond wait smx pipe1
    97 smxRecvSnd 12cpu 07/11 10:49:03 0.0080 1800 sleeping secs: 1
    98 smxrcv ifxsrv5 1cpu 07/11 10:48:56 0.0087 412 sleeping secs: 4
    99 smxsnd_ifxsrv5 9cpu 07/08 14:24:23 0.0000 0 cond wait smx pipe1
    100 smxRecvSnd 8cpu 07/11 10:49:03 0.0077 1800 sleeping secs: 1
    115 smxrcv ifxsrv6 8cpu 07/11 10:49:01 0.0110 408 sleeping secs: 9
    116 smxsnd_ifxsrv6 1cpu 07/08 14:24:31 0.0000 0 cond wait smx pipe1
    117 smxRecvSnd 8cpu 07/11 10:49:03 0.0097 1803 sleeping secs: 1
    118 smxrcv ifxsrv6 1cpu 07/11 10:49:00 0.0107 408 sleeping secs: 8
    119 smxsnd_ifxsrv6 8cpu 07/08 14:24:31 0.0000 0 cond wait smx pipe1
    120 smxRecvSnd 8cpu 07/11 10:49:03 0.0081 1801 sleeping secs: 1
    121 smxrcv ifxsrv6 12cpu 07/11 10:49:00 0.0140 401 sleeping secs: 8
    122 smxsnd_ifxsrv6 8cpu 07/08 14:24:31 0.0000 0 cond wait smx pipe1
    123 smxRecvSnd 8cpu 07/11 10:49:03 0.0085 1798 sleeping secs: 1
    124 smxrcv ifxsrv6 8cpu 07/11 10:48:56 0.0101 409 sleeping secs: 4
    125 smxsnd_ifxsrv6 8cpu 07/08 14:24:31 0.0000 0 cond wait smx pipe1
    126 smxRecvSnd 8cpu 07/11 10:49:03 0.0076 1802 sleeping secs: 1

    Any clue why this ?

    Thank you


    ------------------------------
    Garcia Benjamin
    ------------------------------

    #Informix