Re: go for a script! / ex: PostgreSQL vs. MySQL

On Monday 13 October 2003 19:34, Vivek Khera wrote:
> >>>>> "SC" == Sean Chittenden <sean@chittenden.org> writes:
> >>
> >> echo "effective_cache_size = $((`sysctl -n vfs.hibufspace` / 8192))"
> >>
> >> I've used it for my dedicated servers.  Is this calculation correct?
>
> SC> Yes, or it's real close at least.  vfs.hibufspace is the amount of
> SC> kernel space that's used for caching IO operations (minus the
>
> I'm just curious if anyone has a tip to increase the amount of memory
> FreeBSD will use for the cache?  It appears to me that even on my 2Gb
> box, lots of memory is 'free' that could be used for the cache
> (bumping up shared buffers is another option...) yet the disk is being
> highly utilized according to systat.

Is this of any help?..reverse video sucks though.. especially spec'ed person
like me..

http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2003-07/0073.html

 Shridhar