RE: High BR ratio

Upping LRU's to 128(and probably CLEANERS too) would probably be a good start. Hope this helps, Will >===== Original Message From "Abdel Rashed" <abdel0296@hotmail.com> ===== >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 ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------