Re: 7.31 performance problem
Some details, what platform? Any changes to the onconfig? We found that there were a few changes we had to make to get things up to speed, but not many. In general the engine performed better than 7.24 with no changes to its config brett kt wrote: > > Yes! > > KT > > > did u run update statistics etc ??? -- ----------------------------------------------------------------- Brett's 10th law of UNIX administration... rm is forever ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------
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