Re: Minimizing bufwaits
Brian Hampson wrote:
> =
> It appears, from an onstat -p, that about my only bottlenecks is
> "bufwaits"
> =
> Is there a way that I can reduce the waits? What parameter needs to be=
> twiddled?
> =
> Onstat -p output (note some numbers have rolled over..showing incorrect=
> cache numbers)
> =
> INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 41 days 22:38:10 --=
57984 Kbytes
> =
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 25560000 63513837 36185941 29.36 8964466 35165552 122598911 92.69
Your read cache it=B4s really bad (29,36) , i think you must make bigger=
your buffer pool.
> =
> isamtot open start read write rewrite delete commit =
rollbk
> 2414132832 27171184 136937552 1757719100 35850121 1755389 473948 184=
9956 9
> =
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 441158.86 89765.19 1879 8040
> =
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans=
> 3005610 936 3233912260 2 0 2109 7633098 312212=
9
Yeah! You have too much bufwaits , so you must define more LRU .If ypu
have more LRU.
> =
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 6626719 47054 2294107 8903552 524623
> =
> --
> Please send administrative requests to admin@ASL.CA
> =
> Brian P. Hampson ASL Analytical Service Laboratorie=
s Ltd
> System Administrator, Vancouver, BC (604)253-4188
> ----------------- http://www.ASL.CA/ ----------------------------=
> =
> *****Help Support the 40th Marpole Scouts' Fundraising Drive!!**=
***
> =
> Buy Delicious Top Grade Popcorn and Help Send a Scout to Camp!!=
!
> =
> Email me for details!!
-- =
______________________________________________________
Un saludo civil
http://www.arrakis.es/~ramp =3D> No disponible
vi Powered