Mike Jakubik
2006-Jul-09 20:49 UTC
MySQL and default memory limits (mysqld: Out of memory)
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?
Mathieu Arnold
2006-Jul-09 20:56 UTC
MySQL and default memory limits (mysqld: Out of memory)
+-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. -- Mathieu Arnold -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 187 bytes Desc: not available Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20060709/c5db6b2b/attachment.pgp