Re: 7.31 performance problem
kt had a performance problem on IDS 7.31. Andrew Ford suggested running update statistics since onstat -p showed many sequential scans. David Williams advised setting NOAGE to 1 in the ONCONFIG. Art Kagel said the sequential scans likely stemmed from a sub-query flattening problem he had mentioned. kt said they would wait for IDS 7.31.UD1 on HP 10.20. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Yes I have.
KT
> Have you run update statistics? onstat -p shows a lot of sequential scans.
Have you run update statistics? onstat -p shows a lot of sequential scans.
Andrew
----- Original Message -----
From: "kt" <h78816@loisto.uwasa.fi>
To: <informix-list@iiug.org>
Sent: Tuesday, December 19, 2000 5:33 AM
Subject: Re: 7.31 performance problem
> Here is the missing part from the begin.
>
> > Some details, what platform? Any changes to the onconfig?
>
> HP-UX B.10.20 U 9000/800 149470502 unlimited-user license,Mem 1Gb,4 Cpus
> and we didn't do any changes to the onconfig.
>
>
> onstat -p>
> Informix Dynamic Server Version 7.31.UC7A -- On-Line -- Up 3 days
> 20:36:40 --s
>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 34888757 13259959 1076122339 96.76 2113075 6091650 15551805 86.41
>
> isamtot open start read write rewrite delete commit
> rollbk
> 1512157677 35440471 281060292 298788607 1325622 1017030 1192844 1854130
> 1532
>
> 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 214804.69 18097.62 262 552
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 8106021 7593 279852404 0 0 526 134601 439588
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 14181088 304457 2578107 15544664 318863
>
>
> KT
In article <Pine.GSO.4.30.0012191859330.23349-100000@loisto.uwasa.fi>,
kt <h78816@loisto.uwasa.fi> writes
>Yes I have.
>
>
>KT
>
>> Have you run update statistics? onstat -p shows a lot of sequential scans.
>
Remember to set NOAGE to 1 in the Onconfig file or the Online
processes get 'aged' and so are not allowed to run on the cpu as
often as they need to!
--
David Williams
Those sequential scans are likely a symptom of the sub-query flattening
problem I mentioned.
Art S. Kagel
kt wrote:
>
> Yes I have.
>
> KT
>
> > Have you run update statistics? onstat -p shows a lot of sequential scans.
Hi! Thanks for all, about your advices. We are waiting for HP 10.20, IDS 7.31.UD1 version. If it works better. Any comments about that? KT