Memory usage for MySQL

[Charles Swiger]

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