High BR ratio
Posted in 2000
Hello,
I read in past postings that a BR ratio over 10 will reduce performance.
Right now my system has a BR ratio of 10.46. What is the best way to lower
it? I am puuting some onconfig variables an onstat -v and onstat -R in my
message.
LRU = 30
LRU_MAX_DIRTY = 2
LRU_MIN_DIRTY = 1
RA_PAGES 24
RA_THRESHOLD 20
BUFFERS = 170000
**** ONSTAT -p ****
Informix Dynamic Server Version 7.31.UC4 -- On-Line -- Up 12 days
22:06:04 -- 880128 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1471704 979881 69193148 97.87 100356 77678 443632 77.38
isamtot open start read write rewrite delete commit
rollbk
96043584 1127064 2457047 87763572 107047 29652 18019 26450 6522
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 2801.40 270.71 2 4
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
141562 78 150886365 0 0 117 5073 44033
ixda-RA idx-RA da-RA RA-pgsused lchwaits
480384 14912 858745 1345065 140038
**** ONSTAT -R ****
Informix Dynamic Server Version 7.31.UC4 -- On-Line -- Up 12 days
22:06:52 -- 880128 Kbytes
30 buffer LRU queue pairs priority levels
# f/m pair total % of length LOW MED_LOW MED_HIGH HIGH
0 f 5576 98.1% 5472 0 2869 2574 29
1 m 1.9% 104 0 104 0 0
2 f 5657 98.1% 5551 0 3231 2288 32
3 m 1.9% 106 0 106 0 0
4 f 5623 98.2% 5521 0 3170 2313 38
5 m 1.8% 102 0 102 0 0
6 f 5611 98.0% 5501 0 3073 2400 28
7 m 2.0% 110 0 110 0 0
8 f 5651 98.1% 5541 0 3210 2300 31
9 m 1.9% 110 0 109 1 0
10 f 5596 98.0% 5483 0 3064 2384 35
11 m 2.0% 113 0 113 0 0
12 f 5605 98.6% 5526 0 2788 2709 29
13 m 1.4% 79 0 79 0 0
14 f 5637 98.9% 5573 0 3229 2299 45
15 m 1.1% 64 0 64 0 0
16 f 5630 98.5% 5548 0 3088 2435 25
17 m 1.5% 82 0 81 1 0
18 f 5617 98.6% 5536 0 2798 2703 35
19 m 1.4% 81 0 80 1 0
20 f 5577 98.2% 5474 0 3094 2358 22
21 m 1.8% 103 0 103 0 0
22 f 5597 98.1% 5492 0 3011 2434 47
23 m 1.9% 105 0 105 0 0
24 f 5657 98.1% 5550 0 3212 2301 37
25 m 1.9% 107 0 107 0 0
26 F 5642 98.9% 5579 0 2961 2588 30
27 m 1.1% 63 0 63 0 0
28 f 5590 98.7% 5516 0 3395 2086 36
29 m 1.3% 74 0 74 0 0
30 f 5676 98.5% 5593 0 3322 2231 40
31 m 1.5% 83 0 83 0 0
32 f 5591 98.6% 5514 0 3018 2454 42
33 m 1.4% 77 0 76 1 0
34 f 5651 98.7% 5580 0 3293 2256 31
35 m 1.3% 71 0 69 2 0
36 f 5678 98.4% 5587 0 3210 2344 33
37 m 1.6% 91 0 91 0 0
38 f 5601 98.4% 5514 0 3006 2465 43
39 m 1.6% 87 0 87 0 0
40 f 5625 98.5% 5541 0 3195 2314 32
41 m 1.5% 84 0 83 1 0
42 f 5644 98.8% 5579 0 3255 2284 40
43 m 1.2% 65 0 65 0 0
44 f 5647 98.4% 5558 0 3087 2434 37
45 m 1.6% 89 0 89 0 0
46 f 5652 98.8% 5586 0 2842 2704 40
47 m 1.2% 66 0 66 0 0
48 f 5658 98.3% 5561 0 3119 2411 31
49 m 1.7% 97 0 96 1 0
50 f 5621 98.4% 5531 0 3104 2395 32
51 m 1.6% 90 0 90 0 0
52 f 5653 98.4% 5562 0 3046 2486 30
53 m 1.6% 91 0 91 0 0
54 f 5588 98.0% 5479 0 2939 2506 34
55 m 2.0% 109 0 108 1 0
56 f 5626 98.6% 5547 0 3265 2257 24
57 m 1.4% 79 0 79 0 0
58 f 5671 98.0% 5558 0 3353 2163 42
59 m 2.0% 113 0 113 0 0
2695 dirty, 168848 queued, 170000 total, 262144 hash buckets, 2048 buffer
size
start clean at 2% (of pair total) dirty, or 113 buffs dirty, stop at 1%
0 priority downgrades, 0 priority upgrades
Thank you very much for assistance,
Rashed
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com