From owner-freebsd-stable@FreeBSD.ORG Tue Jul 11 01:07:42 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 0436916A4DA for ; Tue, 11 Jul 2006 01:07:42 +0000 (UTC) (envelope-from jd@ugcs.caltech.edu) Received: from groat.ugcs.caltech.edu (groat.ugcs.caltech.edu [131.215.176.110]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4560443D7F for ; Tue, 11 Jul 2006 01:07:33 +0000 (GMT) (envelope-from jd@ugcs.caltech.edu) Received: by groat.ugcs.caltech.edu (Postfix, from userid 3640) id C6C8D5880B; Mon, 10 Jul 2006 18:07:32 -0700 (PDT) Date: Mon, 10 Jul 2006 18:07:32 -0700 From: Paul Allen To: Mike Jakubik Message-ID: <20060711010732.GC12597@groat.ugcs.caltech.edu> References: <44B16BE9.60508@rogers.com> <44B176D2.3080501@rogers.com> <44B276F7.4070507@mac.com> <44B28B7F.1000507@rogers.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44B28B7F.1000507@rogers.com> Sender: jd@ugcs.caltech.edu 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: Tue, 11 Jul 2006 01:07:42 -0000 >From Mike Jakubik , Mon, Jul 10, 2006 at 01:16:47PM -0400: > Chuck Swiger wrote: > >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. > > > > Such as a database server. I just think it would be nicer if this limit > was dynamically set, based on your configuration. Just like MAXUSERS was > a kernel variable, it is now dynamically set based on your resources. This is nonsense. maxdsiz is not related to rlimit per se. There is no way to examine a system's hardware to pick this value. The proper value depends entirely on whether your programs place more load on brk or mmap. > > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"