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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
