From owner-freebsd-stable@FreeBSD.ORG Mon Jul 10 16:13:09 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 57D0216A4E0 for ; Mon, 10 Jul 2006 16:13:09 +0000 (UTC) (envelope-from andrej@antiszoc.hu) Received: from andrej.mine.nu (catv-d5debe68.catv.broadband.hu [213.222.190.104]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3624C43D6D for ; Mon, 10 Jul 2006 16:13:06 +0000 (GMT) (envelope-from andrej@antiszoc.hu) Message-ID: <44B27CD0.3050701@antiszoc.hu> Date: Mon, 10 Jul 2006 18:14:08 +0200 From: Andras Got User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.2) Gecko/20060404 SeaMonkey/1.0.1 MIME-Version: 1.0 To: stable@freebsd.org References: <44B16BE9.60508@rogers.com> <44B176D2.3080501@rogers.com> <44B276F7.4070507@mac.com> In-Reply-To: <44B276F7.4070507@mac.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit Cc: Mike Jakubik 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 16:13:09 -0000 Hi, IMHO on servers 2G is common these these days, and 4G will be common very soon. As people use the websites and the internet more, the needed resources are growing fast. This 512MB will be soon revised imho. :) For example I run a little hosting server for my company and 2 years ago a 2,4Ghz xeon was more than enough. This year I had to replace that machine with an X2100 with 2G RAM because of the customer needs. The number of the pages hadn't grown significally, just the number of served pages and of course the mysql databases. Andras Chuck Swiger wrote: > 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. >