Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 10 Jul 2006 18:07:32 -0700
From:      Paul Allen <nospam@ugcs.caltech.edu>
To:        Mike Jakubik <mikej@rogers.com>
Cc:        stable@freebsd.org
Subject:   Re: MySQL and default memory limits (mysqld: Out of memory)
Message-ID:  <20060711010732.GC12597@groat.ugcs.caltech.edu>
In-Reply-To: <44B28B7F.1000507@rogers.com>
References:  <44B16BE9.60508@rogers.com> <E56FEA0F58A776685B3AB5DF@[192.168.1.5]> <44B176D2.3080501@rogers.com> <44B276F7.4070507@mac.com> <44B28B7F.1000507@rogers.com>

next in thread | previous in thread | raw e-mail | index | archive | help
>From Mike Jakubik <mikej@rogers.com>, Mon, Jul 10, 2006 at 01:16:47PM -0400:
> Chuck Swiger wrote:
> >512MB is more than enough for almost all processes to run just fine, 
> >and is only really inappropriate for the case where you've got 1-plus 
> >GB of physical RAM and want to dedicate the system to a single large 
> >task, or perhaps a single-digit number of processes if you've got 
> >several GB of physical RAM.
> >
> 
> Such as a database server. I just think it would be nicer if this limit 
> was dynamically set, based on your configuration. Just like MAXUSERS was 
> a kernel variable, it is now dynamically set based on your resources.
This is nonsense.  maxdsiz is not related to rlimit per se.

There is no way to examine a system's hardware to pick this value.

The proper value depends entirely on whether your programs place more load 
on brk or mmap.





> 
> 
> _______________________________________________
> freebsd-stable@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060711010732.GC12597>