From owner-freebsd-questions@FreeBSD.ORG  Wed Jul 19 17:38:54 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6282D16A4DA
	for <freebsd-questions@freebsd.org>;
	Wed, 19 Jul 2006 17:38:54 +0000 (UTC) (envelope-from cswiger@mac.com)
Received: from pi.codefab.com (pi.codefab.com [199.103.21.227])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0826843D53
	for <freebsd-questions@freebsd.org>;
	Wed, 19 Jul 2006 17:38:53 +0000 (GMT) (envelope-from cswiger@mac.com)
Received: from localhost (localhost [127.0.0.1])
	by pi.codefab.com (Postfix) with ESMTP id 1398A5D44;
	Wed, 19 Jul 2006 13:38:53 -0400 (EDT)
X-Virus-Scanned: amavisd-new at codefab.com
Received: from pi.codefab.com ([127.0.0.1])
	by localhost (pi.codefab.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id f9m2v2W1GulE; Wed, 19 Jul 2006 13:38:52 -0400 (EDT)
Received: from [199.103.21.238] (pan.codefab.com [199.103.21.238])
	(using TLSv1 with cipher RC4-SHA (128/128 bits))
	(No client certificate requested)
	by pi.codefab.com (Postfix) with ESMTP id 57A985D40;
	Wed, 19 Jul 2006 13:38:52 -0400 (EDT)
In-Reply-To: <407487AA-A1C4-4581-A7EA-2FBC68E284C6@dm1.net>
References: <407487AA-A1C4-4581-A7EA-2FBC68E284C6@dm1.net>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <DBF98FDA-4FE1-4550-854B-A55F8B86BD48@mac.com>
Content-Transfer-Encoding: 7bit
From: Charles Swiger <cswiger@mac.com>
Date: Wed, 19 Jul 2006 13:38:51 -0400
To: Thaddeus Quintin <thaddeus@dm1.net>
X-Mailer: Apple Mail (2.752.2)
Cc: freebsd-questions@freebsd.org
Subject: Re: Memory usage for MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 19 Jul 2006 17:38:54 -0000

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