From owner-freebsd-stable@FreeBSD.ORG  Sun Jul  9 21:14:19 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 CEF2916A4DA;
	Sun,  9 Jul 2006 21:14:19 +0000 (UTC)
	(envelope-from darren.pilgrim@bitfreak.org)
Received: from mail.twinthornes.com (mail.twinthornes.com [65.75.198.147])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4DA3443D45;
	Sun,  9 Jul 2006 21:14:18 +0000 (GMT)
	(envelope-from darren.pilgrim@bitfreak.org)
Received: from [10.242.169.24] (c-67-171-135-169.hsd1.or.comcast.net
	[67.171.135.169])
	by mail.twinthornes.com (Postfix) with ESMTP id CFE264F;
	Sun,  9 Jul 2006 14:14:17 -0700 (PDT)
Message-ID: <44B171AA.9080400@bitfreak.org>
Date: Sun, 09 Jul 2006 14:14:18 -0700
From: Darren Pilgrim <darren.pilgrim@bitfreak.org>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: Mathieu Arnold <mat@FreeBSD.org>
References: <44B16BE9.60508@rogers.com>
	<E56FEA0F58A776685B3AB5DF@[192.168.1.5]>
In-Reply-To: <E56FEA0F58A776685B3AB5DF@[192.168.1.5]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org
Subject: Re: 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 21:14:19 -0000

Mathieu Arnold wrote:
> +-Le 09/07/2006 16:49 -0400, Mike Jakubik a dit :
 > | 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.

That OID doesn't seem to exist:

 > uname -pr
6.0-RELEASE-p1 i386
 > sysctl -N kern | grep max
kern.maxvnodes
kern.maxproc
kern.maxfiles
kern.argmax
kern.maxfilesperproc
kern.maxprocperuid
kern.ipc.maxsockbuf
kern.ipc.somaxconn
kern.ipc.max_linkhdr
kern.ipc.max_protohdr
kern.ipc.max_hdr
kern.ipc.max_datalen
kern.ipc.maxpipekva
kern.ipc.msgmax
kern.ipc.shmmax
kern.ipc.maxsockets
kern.iov_max
kern.kq_calloutmax
kern.maxusers
kern.threads.max_threads_per_proc
kern.threads.max_groups_per_proc
kern.threads.max_threads_hits
kern.smp.maxcpus

-- 
Darren Pilgrim