MySQL and default memory limits (mysqld: Out of memory)

[Paul Allen]

>From Mike Jakubik <mikej at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"