RE: Opinions on usercpu & syscpu in onstat -p
On a 6 way box, assuming you have say 5 CPU VPs, then no.
150951 + 5282 = 156233 total CPU usage
over a period of 67740 seconds you would have
5 * 67740 = 338700 total seconds of CPU usage available
So, your using a little less than half.
If you are trying to determine if you have a CPU bottleneck, it is a lot
easier from the OS side using sar, vmstat, etc.
Bill
> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org]
> On Behalf Of Darren_Jacobs@carmax.com
> Sent: Thursday, April 07, 2005 11:47 AM
> To: informix-list@iiug.org; ids@iiug.org
> Subject: Opinions on usercpu & syscpu in onstat -p
>
> Just wanted to get some opinions on the usercpu and syscpu meaning in
> the
> onstat -p output. I can't remember if I read in Lumbley's guide or
> not,> but if usercpu exceeds the amount of lapsed time this indicates the
> system
> could benefit from more physical cpus. Below is an onstat -p output
> where
> total elapsed time is 67740 seconds. User cpu more than twice that at
> 150,951
>
> HP N Class 6 Way 550's
> 6 gig Physical Mem.
> HPUX 11
> 9.40 FC2
>
>
> IBM Informix Dynamic Server Version 9.40.FC2W4 -- On-Line -- Up 2> days
> 20:32:50 -- 3918780 Kbytes
>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 58767865 124325277 12739374150 99.54 4592164 31893241 24004499
> 80.87
>
> isamtot open start read write rewrite delete commit
> rollbk
> 7825834138 6479678 83176707 6822458070 178820294 1276025 720792
> 80860
> 488
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> 0 0 0 0 0 0 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 150951.57 5282.00 143 429
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress
> seqscans
> 3446881 2048 12220794081 23 0 512 480281
> 5784056
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 13697305 1729291 18192868 33137079 94700177
>
>
> sending to informix-list
sending to informix-list