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

[Mike Jakubik]

Mathieu Arnold wrote:
> +-Le 09/07/2006 16:49 -0400, Mike Jakubik a dit :
> | I just setup a new system with MySQL 5.0.22, and to my surprise i get
> | this error in MySQL's log.
> | 
> | /usr/local/libexec/mysqld: Out of memory (Needed 237527040 bytes)
> | /usr/local/libexec/mysqld: Out of memory (Needed 178145280 bytes)
> | 
> | The system has 1GB of ram, which is plenty for MySQLs configuration (its
> | using the my-large.cnf, which is tuned for a system of 512MB)
> | 
> | 
> | Why am i getting this error? I read somewhere that FreeBSD by default
> | limits process size to 512MB, however the variables used to tune it do
> | not seems to exist in FreeBSD-6.1 any more. How can i let MySQL use more
> | memory?
>
> If you're using a i386, the max process memory size limit is at 512M,
> you'll have to tune kern.maxdsiz in /boot/loader.conf to say 1G.
>
>   

Why are the limits so low by default? In any case, this is what i found 
in LINT.

options         MAXDSIZ=(1024UL*1024*1024)
options         MAXSSIZ=(128UL*1024*1024)
options         DFLDSIZ=(1024UL*1024*1024)

I have no idea what those values mean, what should i set them to to be 
safe? A limit 768MB should work for me.