Re: Informix Performance Issues
Obnoxio The Chav wrote:
> Anirudh Chitnis via DBMonster.com said:
>
>>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
>>
>>1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19
>
>
> Well, there's your problem right there -- 90.7% read cache rate. You
> definitely need more buffers.
>
Humm haaa ...
Well, I agree to taking your buffers up to 800,000 - spread over 256
LRUS - so 6.5 Mb per LRU seems okey dokey too.
Why not look at RA_PAGES and RA_THRESHOLD, 'cos you are pumping through
this data at a fair rate when looking at your io/s :
onstat -g iovclass/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
errors
kio 0 s 542.1 266043030 262575149 3467881 0 505359119 0.5
0
kio 1 s 301.4 147943204 144184932 3758272 0 268265145 0.6
0
kio 2 s 317.3 155740487 152138171 3602316 0 287022047 0.5
Try something silly at least once :D
RA_PAGES 1024
RA_THRESHOLD 64
would be cranking it high.
For a "mix" try
RA_PAGES 128
RA_THRESHOLD 16
--
"I have enough problems remembering my opinions, let alone justifying them."
"Sorry, I thought you tapped me."