From owner-freebsd-stable@FreeBSD.ORG Mon Jul 10 15:49:22 2006 Return-Path: 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 E582116A4E1 for ; Mon, 10 Jul 2006 15:49:22 +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 5C28843D4C for ; Mon, 10 Jul 2006 15:49:22 +0000 (GMT) (envelope-from cswiger@mac.com) Received: from localhost (localhost [127.0.0.1]) by pi.codefab.com (Postfix) with ESMTP id A32A25F36; Mon, 10 Jul 2006 11:49:21 -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 j+QsvqYh6mlM; Mon, 10 Jul 2006 11:49:18 -0400 (EDT) Received: from [192.168.1.251] (pool-68-161-117-245.ny325.east.verizon.net [68.161.117.245]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by pi.codefab.com (Postfix) with ESMTP id 86D0D5D9C; Mon, 10 Jul 2006 11:49:18 -0400 (EDT) Message-ID: <44B276F7.4070507@mac.com> Date: Mon, 10 Jul 2006 11:49:11 -0400 From: Chuck Swiger User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Mike Jakubik References: <44B16BE9.60508@rogers.com> <44B176D2.3080501@rogers.com> In-Reply-To: <44B176D2.3080501@rogers.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 10 Jul 2006 15:49:23 -0000 Mike Jakubik wrote: [ ... ] > Why are the limits so low by default? In any case, this is what i found > in LINT. > > options MAXDSIZ=(1024UL*1024*1024) > options MAXSSIZ=(128UL*1024*1024) > options DFLDSIZ=(1024UL*1024*1024) > > I have no idea what those values mean, what should i set them to to be > safe? A limit 768MB should work for me. 512MB is more than enough for almost all processes to run just fine, and is only really inappropriate for the case where you've got 1-plus GB of physical RAM and want to dedicate the system to a single large task, or perhaps a single-digit number of processes if you've got several GB of physical RAM. -- -Chuck PS: On the other hand, as time passes and 64-bit hardware with 4+ GB of RAM becomes more common, this 512MB limit starts resembling the "640K is more than enough" comment from years past. Core memory used to cost a dollar a bit, rather than a dollar a megabit today, but that was before my time... :-)