Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig

David L. Kosenko wrote: > > If LRU_MAX_DIRTY is set to 5 with 10 LRUS, the start flush point is > going to be > essentially the same as a LRU_MAX_DIRTY of 5 with 20 LRUS. Why? > Because dirty > buffers are generally spread evenly across all Qs (we access LRUs > randomly, more > or less). So while it takes fewer dirty buffers to reach that point, > because > you now have more LRUS to work with, they will reach that point no > faster. So > increasing LRUS will not have a significant impact on reducing chunk > writes. As I > have said here before, to reduce chunk writes, decrease LRU_MAX_DIRTY. > <SNIP> So you spotted that I was a version 5.00 tuner then! This input was all great and I would like to hear more of this. Particularly the differences between tuning a version 5.xx system and a version 7.1x system. You lot are probably running 7.3 by now. Here in the bush, we still have sites running 1.1, 2.1, 4.0, 4.1, 5.0, 6.0, etc. As yet not many version 7.10 sites to play on (er... I mean tune up). But the numbers are increasing, so if you have put any of this stuff in a FAQ then let us know. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+