From owner-freebsd-stable@FreeBSD.ORG Sun Jul 9 21:39:17 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 C051416A4EB; Sun, 9 Jul 2006 21:39:17 +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 1675843F67; Sun, 9 Jul 2006 21:36:06 +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 9A6ED114F1; Sun, 9 Jul 2006 17:36:32 -0400 (EDT) Message-ID: <44B176D2.3080501@rogers.com> Date: Sun, 09 Jul 2006 17:36:18 -0400 From: Mike Jakubik User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Mathieu Arnold References: <44B16BE9.60508@rogers.com> In-Reply-To: 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: 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: Sun, 09 Jul 2006 21:39:17 -0000 Mathieu Arnold wrote: > +-Le 09/07/2006 16:49 -0400, Mike Jakubik a dit : > | 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? > > 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. > > 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.