RE: LRU writes

> -----Original Message----- > From: Franklin Tang [SMTP:franklin@macauslot.com] > Sent: Monday, May 05, 2003 8:13 AM > To: informix-list@iiug.org > Subject: LRU writes > > Dear, > I have a problem on the LRU writes , the figure for LRU compares to > Chunk writes has a huge difference. E.g. > > Fg Writes LRU Writes Chunk Writes > 0 4600 1094394 > > > I want to increase the LRU writes to reduce the chunch wirtes. Should I > reduce the number of LRU??? > Why? Are your checkpoints taking too long? OLTP of Data Warehouse? Assuming you really do want to cause more LRU writes because of excessive checkpoint duration, simply reducing the number of LRUs won't work. That would increase the number of buffers per LRU. It will then take longer to reach the value for LRU_MAX_DIRTY. You would get less LRU writes than before. The parameters LRU, LRU_MAX_DIRTY, LRU_MIN_DIRTY, CLEANERS, CKPTINTVL and BUFFERS should all be tuned together to reduce checkpoints. Tune BUFFERS to get the required read/write cache percentage and then tune the others for optimal checkpoint duration for that number of buffers. Post your onconfig file for recommendations. Regards, Bill Dare > Thx > Franklin >