Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 19 Jul 2006 13:38:51 -0400
From:      Charles Swiger <cswiger@mac.com>
To:        Thaddeus Quintin <thaddeus@dm1.net>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Memory usage for MySQL
Message-ID:  <DBF98FDA-4FE1-4550-854B-A55F8B86BD48@mac.com>
In-Reply-To: <407487AA-A1C4-4581-A7EA-2FBC68E284C6@dm1.net>
References:  <407487AA-A1C4-4581-A7EA-2FBC68E284C6@dm1.net>

next in thread | previous in thread | raw e-mail | index | archive | help
On Jul 19, 2006, at 1:14 PM, Thaddeus Quintin wrote:
> The issue that I'm having is that when I start up MySQL I get a  
> couple "Out of Memory" errors before it actually starts up.  Looks  
> like this-
>
> 060719 11:55:35  InnoDB: Started; log sequence number 0 43656
> /usr/local/libexec/mysqld: Out of memory (Needed 950109184 bytes)
> /usr/local/libexec/mysqld: Out of memory (Needed 712581120 bytes)
> 060719 11:55:35 [Note] /usr/local/libexec/mysqld: ready for  
> connections.
> Version: '5.0.22-log'  socket: '/tmp/mysql.sock'  port: 3306

FreeBSD defaults to having a 512MB maximum process datasize.  Add  
something like:

	kern.dfldsiz="1G"

...to /boot/loader.conf.

-- 
-Chuck




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?DBF98FDA-4FE1-4550-854B-A55F8B86BD48>