Better Manuals (was: Re: Mirroring)

Hi Art, >I know what the manuals say (one cleaner per disk and fewer LRUs is >better). The manuals are WRONG. The Informix benchmark people long >ago proved that and I have verified it myself. If your goal is to best >share the machine with other apps and servers and minimize impact on the >OS and hardware, follow the manuals. If you want maximum transaction >throughput, for BUFFERS=100000 go with 32 LRUs, 32 cleaners, >MAX_DIRTY < 10, MIN_DIRTY < 5. Adjust as appropriate. In this scheme >ignore the fact that you have mirrors, there will be plenty of free >cleaners to flush to the mirrors during Idle Write wake ups and LRU wake >ups and if your activity level is so high that there are still >significant numbers of dirty pages at checkpoint time you know that >there will be more cleaners than disk so... Have you sent this observation to the doc@informix.com alias? They invite your opinion on the last page of the Introduction in each book, and appreciate suggestions on how to make the manuals better. I recommend that you write up a page showing how you think the manuals *should* look and send it on. Together we can make the world a better place. ;) Clem ______________________________________________________ Clem Akins (aka clema@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: Sipping dessert wine in an Auckland bistro