From owner-freebsd-stable@FreeBSD.ORG  Sun Jul  9 20:49:33 2006
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: stable@freebsd.org
Delivered-To: freebsd-stable@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 2C2F516A4DA
	for <stable@freebsd.org>; Sun,  9 Jul 2006 20:49:33 +0000 (UTC)
	(envelope-from mikej@rogers.com)
Received: from H43.C18.B96.tor.eicat.ca (H43.C18.B96.tor.eicat.ca
	[66.96.18.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id C61BE43D45
	for <stable@freebsd.org>; Sun,  9 Jul 2006 20:49:32 +0000 (GMT)
	(envelope-from mikej@rogers.com)
Received: from [127.0.0.1] (desktop.home.local [172.16.0.200])
	by H43.C18.B96.tor.eicat.ca (Postfix) with ESMTP id 00704114EC
	for <stable@freebsd.org>; Sun,  9 Jul 2006 16:50:00 -0400 (EDT)
Message-ID: <44B16BE9.60508@rogers.com>
Date: Sun, 09 Jul 2006 16:49:45 -0400
From: Mike Jakubik <mikej@rogers.com>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: stable@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-SpamToaster-Information: This messages has been scanned by SpamToaster
	http://www.digitalprogression.ca
X-SpamToaster: Found to be clean
X-SpamToaster-SpamCheck: not spam, SpamAssassin (not cached, score=-2.49,
	required 3.5, ALL_TRUSTED -1.80, AWL 0.00, BAYES_00 -2.60,
	DK_POLICY_SIGNSOME 0.00, DNS_FROM_RFC_ABUSE 0.20,
	DNS_FROM_RFC_POST 1.71)
X-SpamToaster-From: mikej@rogers.com
X-Spam-Status: No
Cc: 
Subject: MySQL and default memory limits (mysqld: Out of memory)
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 09 Jul 2006 20:49:33 -0000

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?