Informix

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