CPU VP utilization
I have 2 different servers.
1st - 1 CPU 155 MHz Pentium, 64 MB RAM, 1 HD
2nd - 1 CPU 300 MHz Pentium II, 64 MB RAM, 1 HD
Both have IDS 7.2 but they have differences in Informix configuration.
1st 2nd
NUMAIOVPS 3 1
CLEANERS 16 1
LRUS 16 8
Here are some outputs from onstat
-------------------------1st------------------------------------------------------------
INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:46:30 -- 29464 Kbytes
MT global info:
sessions threads vps lngspins
7 37 9 0
sched calls thread switches yield 0 yield n yield forever
total: 769064 461334 325902 69794 18396
per sec: 9 4 5 2 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 1 588.23 53.36 641.59
aio 3 2.92 7.62 10.54
tli 1 0.26 1.07 1.33
lio 1 1.89 3.09 4.98
pio 1 1.09 0.44 1.53
adm 1 0.04 0.69 0.73
msc 1 0.64 0.13 0.77
total 9 595.07 66.40 661.47
Individual virtual processors:
vp pid class usercpu syscpu total
1 417 cpu 588.23 53.36 641.59
2 418 adm 0.04 0.69 0.73
3 419 lio 1.89 3.09 4.98
4 420 pio 1.09 0.44 1.53
5 421 aio 1.06 2.99 4.05
6 422 msc 0.64 0.13 0.77
7 423 aio 0.70 2.42 3.12
8 424 aio 1.16 2.21 3.37
9 425 tli 0.26 1.07 1.33
tot 595.07 66.40 661.47
INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:53:33 -- 21272 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
3894 3928 1953864 99.80 13308 21209 54567 75.61
isamtot open start read write rewrite delete commit rollbk
1357028 54079 144150 749643 12761 3079 565 3978 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 601.84 66.89 94 188
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
1335 1 3523911 0 0 18 1907 2336
ixda-RA idx-RA da-RA RA-pgsused lchwaits
2063 11 330 2358 6
-------------------end 1st--------------------------------------------
------------------------------------2nd-----------------------------------
INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:57:52 -- 21272 Kbytes
MT global info:
sessions threads vps lngspins
5 18 7 0
sched calls thread switches yield 0 yield n yield forever
total: 3059689 933468 2344549 71595 18085
per sec: 9 4 5 2 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 1 143.64 11.13 154.77
aio 1 0.63 1.50 2.13
tli 1 0.07 3.27 3.34
lio 1 0.97 0.94 1.91
pio 1 0.68 0.21 0.89
adm 1 0.00 1.04 1.04
msc 1 1.00 0.00 1.00
total 7 146.99 18.09 165.08
Individual virtual processors:
vp pid class usercpu syscpu total
1 469 cpu 143.64 11.13 154.77
2 470 adm 0.00 1.04 1.04
3 471 lio 0.97 0.94 1.91
4 472 pio 0.68 0.21 0.89
5 473 aio 0.63 1.50 2.13
6 474 msc 1.00 0.00 1.00
7 475 tli 0.07 3.27 3.34
tot 146.99 18.09 165.08
INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:58:01 -- 21272 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
5078 5112 2124680 99.76 13629 21146 69344 80.35
isamtot open start read write rewrite delete commit rollbk
1486186 61076 136780 814484 20667 5679 516 4922 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 146.99 18.09 91 190
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
2096 0 4179240 0 0 11 2700 2659
ixda-RA idx-RA da-RA RA-pgsused lchwaits
1988 30 303 2310 0
------------------------end 2nd---------------------------------------
QUESTION:
2nd server did more transactions (25% more) but spent less syscpu and usercpu
(1st
class vps usercpu syscpu total
cpu 1 588.23 53.36 641.59
2nd
class vps usercpu syscpu total
cpu 1 143.64 11.13 154.77
Why is that so? Because of better hardware or because of more AIOVPS and/or
CLEANERS on 1st server?
Thanks
Nebojsa
Your analysis is likely correct.
Art S. Kagel
Nebojsa Sevo wrote:
>
> I have 2 different servers.
>
> 1st - 1 CPU 155 MHz Pentium, 64 MB RAM, 1 HD
> 2nd - 1 CPU 300 MHz Pentium II, 64 MB RAM, 1 HD
>
> Both have IDS 7.2 but they have differences in Informix configuration.
>
> 1st 2nd
> NUMAIOVPS 3 1
> CLEANERS 16 1
> LRUS 16 8>
> Here are some outputs from onstat
>
> -------------------------1st------------------------------------------------------------
> INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:46:30 -- 29464 Kbytes
>
> MT global info:
> sessions threads vps lngspins
> 7 37 9 0
>
> sched calls thread switches yield 0 yield n yield forever
> total: 769064 461334 325902 69794 18396
> per sec: 9 4 5 2 0
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 1 588.23 53.36 641.59
> aio 3 2.92 7.62 10.54
> tli 1 0.26 1.07 1.33
> lio 1 1.89 3.09 4.98
> pio 1 1.09 0.44 1.53
> adm 1 0.04 0.69 0.73
> msc 1 0.64 0.13 0.77
> total 9 595.07 66.40 661.47
>
> Individual virtual processors:
> vp pid class usercpu syscpu total
> 1 417 cpu 588.23 53.36 641.59
> 2 418 adm 0.04 0.69 0.73
> 3 419 lio 1.89 3.09 4.98
> 4 420 pio 1.09 0.44 1.53
> 5 421 aio 1.06 2.99 4.05
> 6 422 msc 0.64 0.13 0.77
> 7 423 aio 0.70 2.42 3.12
> 8 424 aio 1.16 2.21 3.37
> 9 425 tli 0.26 1.07 1.33
> tot 595.07 66.40 661.47
>
> INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:53:33 -- 21272 Kbytes
>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 3894 3928 1953864 99.80 13308 21209 54567 75.61
>
> isamtot open start read write rewrite delete commit rollbk
> 1357028 54079 144150 749643 12761 3079 565 3978 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 601.84 66.89 94 188
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 1335 1 3523911 0 0 18 1907 2336
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 2063 11 330 2358 6
> -------------------end 1st--------------------------------------------
>
> ------------------------------------2nd-----------------------------------
>
> INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:57:52 -- 21272 Kbytes
>
> MT global info:
> sessions threads vps lngspins
> 5 18 7 0
>
> sched calls thread switches yield 0 yield n yield forever
> total: 3059689 933468 2344549 71595 18085
> per sec: 9 4 5 2 0
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 1 143.64 11.13 154.77
> aio 1 0.63 1.50 2.13
> tli 1 0.07 3.27 3.34
> lio 1 0.97 0.94 1.91
> pio 1 0.68 0.21 0.89
> adm 1 0.00 1.04 1.04
> msc 1 1.00 0.00 1.00
> total 7 146.99 18.09 165.08
>
> Individual virtual processors:
> vp pid class usercpu syscpu total
> 1 469 cpu 143.64 11.13 154.77
> 2 470 adm 0.00 1.04 1.04
> 3 471 lio 0.97 0.94 1.91
> 4 472 pio 0.68 0.21 0.89
> 5 473 aio 0.63 1.50 2.13
> 6 474 msc 1.00 0.00 1.00
> 7 475 tli 0.07 3.27 3.34
> tot 146.99 18.09 165.08
>
> INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 07:58:01 -- 21272 Kbytes
>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 5078 5112 2124680 99.76 13629 21146 69344 80.35
>
> isamtot open start read write rewrite delete commit rollbk
> 1486186 61076 136780 814484 20667 5679 516 4922 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 146.99 18.09 91 190
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 2096 0 4179240 0 0 11 2700 2659
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 1988 30 303 2310 0
>
> ------------------------end 2nd---------------------------------------
>
> QUESTION:
>
> 2nd server did more transactions (25% more) but spent less syscpu and usercpu
> (1st
> class vps usercpu syscpu total
> cpu 1 588.23 53.36 641.59
>
> 2nd
> class vps usercpu syscpu total
> cpu 1 143.64 11.13 154.77
>
> Why is that so? Because of better hardware or because of more AIOVPS and/or
> CLEANERS on 1st server?>
> Thanks
>
> Nebojsa