Date: Sun, 09 Jul 2006 17:36:18 -0400 From: Mike Jakubik <mikej@rogers.com> To: Mathieu Arnold <mat@FreeBSD.org> Cc: stable@freebsd.org Subject: Re: MySQL and default memory limits (mysqld: Out of memory) Message-ID: <44B176D2.3080501@rogers.com> In-Reply-To: <E56FEA0F58A776685B3AB5DF@[192.168.1.5]> References: <44B16BE9.60508@rogers.com> <E56FEA0F58A776685B3AB5DF@[192.168.1.5]>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44B176D2.3080501>