Minimizing bufwaits
Posted in 1998
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
isamtot open start read write rewrite delete commit rollbk
2414132832 27171184 136937552 1757719100 35850121 1755389 473948 1849956 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 3122129
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 Laboratories 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!!