Informix

 View Only

IFX 14.10xc8 Updatable RSS and CPU Usage

  • 1.  IFX 14.10xc8 Updatable RSS and CPU Usage

    Posted Mon July 11, 2022 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
    ------------------------------