Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 09 Jul 2006 16:49:45 -0400
From:      Mike Jakubik <mikej@rogers.com>
To:        stable@freebsd.org
Subject:   MySQL and default memory limits (mysqld: Out of memory)
Message-ID:  <44B16BE9.60508@rogers.com>

next in thread | raw e-mail | index | archive | help
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?





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