Bad performance
Hi folks,
we have three servers running Linux (SLES7) and
Informix 9.30 (2x) and 9.21 (1x). A developer
has run a script against 9.21 and it worked
fine and performantly. Now running it against
the 9.30ies shows a very bad performance.
Has somebody perhaps an idea of what is the problem?
Checkpoints are ok at 0 secs.
One thing that I remarked was the the syscpu
time for the adm vp in onstat -g glo:
at 15:00h, before the script started, everything ok.
------------------------------------------------------------
Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 8 days
06:05:56 --
MT global info:
sessions threads vps lngspins
0 60 40 7251
sched calls thread switches yield 0 yield n yield
forever
total: 144106883 101185476 43085549 5878004 13642155
per sec: 4 4 0 2 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 3 16688.20 1230.46 17918.66
aio 32 278.96 1521.65 1800.61
lio 1 4.09 21.07 25.16
pio 1 2.60 23.30 25.90
adm 1 10.08 32.21 42.29
soc 1 288.89 1586.73 1875.62
msc 1 0.55 0.58 1.13
total 40 17273.37 4416.00 21689.37
------------------------------------------------------------
made an onstat -z
at 16:00h, the script is running for about 45 mins, adm very high.
------------------------------------------------------------
Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 8 days
07:05:55 --
MT global info:
sessions threads vps lngspins
1 61 40 0
sched calls thread switches yield 0 yield n yield
forever
total: 154699 151170 3464 3411 72882
per sec: 326 321 5 8 155
Virtual processor summary:
class vps usercpu syscpu total
cpu 3 10.35 0.99 11.34
aio 32 0.24 0.81 1.05
lio 1 0.07 0.16 0.23
pio 1 0.01 0.03 0.04
adm 1 2.60 631.13 633.73
soc 1 0.02 0.00 0.02
msc 1 0.00 0.00 0.00
total 40 13.29 633.12 646.41
------------------------------------------------------------
at 17:00h, script is still running, adm still using more power.
------------------------------------------------------------
Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 8 days
08:05:55 --
MT global info:
sessions threads vps lngspins
1 61 40 0
sched calls thread switches yield 0 yield n yield
forever
total: 571660 557884 13572 12492 268611
per sec: 302 297 5 8 142
Virtual processor summary:
class vps usercpu syscpu total
cpu 3 37.82 3.56 41.38
aio 32 0.93 2.94 3.87
lio 1 0.18 0.97 1.15
pio 1 0.03 0.06 0.09
adm 1 9.55 2317.79 2327.34
soc 1 0.09 0.13 0.22
msc 1 0.00 0.00 0.00
total 40 48.60 2325.45 2374.05