Date: Sun, 09 Jul 2006 22:56:41 +0200 From: Mathieu Arnold <mat@FreeBSD.org> To: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org Subject: Re: MySQL and default memory limits (mysqld: Out of memory) Message-ID: <E56FEA0F58A776685B3AB5DF@[192.168.1.5]> In-Reply-To: <44B16BE9.60508@rogers.com> References: <44B16BE9.60508@rogers.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--==========64711100E0026705A59E========== Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline +-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 --==========64711100E0026705A59E========== Content-Type: application/pgp-signature Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) iD8DBQFEsW2KJqR8av5thQ8RAm91AJ9tfq4YM7JrsBKvBTFSqtPIDtPdjACgqd9k JrH50nDrWK3fipiE45wGL6M= =Ia3D -----END PGP SIGNATURE----- --==========64711100E0026705A59E==========--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E56FEA0F58A776685B3AB5DF>