Re: tuning questions

On Thursday 04 December 2003 23:16, Jack Coates wrote:
>
> > > effective_cache_size = 10000
> >
> > This is way the heck too low.  it's supposed to be the size of all
> > available RAM; I'd set it to 2GB*65% as a start.
>
> This makes a little bit of difference. I set it to 65% (15869 pages).

That's still only about 127MB (15869 * 8KB).

> Now we have some real disk IO:
>    procs                      memory    swap          io
> system         cpu
>  r  b  w   swpd   free   buff  cache  si  so    bi    bo   in    cs  us
> sy  id
>  0  3  1   2804  10740  40808 1899856   0   0 26624     0  941  4144

According to this your cache is currently 1,899,856 KB which in 8KB blocks is
237,482 - be frugal and say effective_cache_size = 200000 (or even 150000 if
the trace above isn't typical).

--
  Richard Huxton
  Archonet Ltd