Re: Good Buffer Size For Tuning Informix?

Hi Michael, The only really important factor in determining the number of buffers is the read and write cache hit ratios reported by tbstat -p. Keep increasing the number of buffers until these cache hit rates do not increase when the system is running a 'normal' workload. This number of buffers is optimum for the workload. Having significantly more buffers than this optimum simply wastes valuable memory. Michael Mstowski wrote: > I've added another 128MB of ram to our HP/UX system running > Informix 5.03. I have a total of 384MB and > a buffer size of 3,000 buffers and 10MB total of shared memory > for Informix. > > I was going to bump this to 27MB of shared memory, with > buffers going up to 10,000. > > Question: Is this a good thing to do and what are the > tradeoffs? -- Chris Jenkins (chrisj@informix.com) >>> All statements and opinions are mine and should in no way <<< >>> be construed as representing those of Informix Software <<<