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.
_______________________________________________
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "[EMAIL PROTECTED]"