From owner-freebsd-stable@FreeBSD.ORG Mon Jul 10 07:42:25 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 4444716A4F3; Mon, 10 Jul 2006 07:42:25 +0000 (UTC) (envelope-from peterjeremy@optushome.com.au) Received: from mail27.syd.optusnet.com.au (mail27.syd.optusnet.com.au [211.29.133.168]) by mx1.FreeBSD.org (Postfix) with ESMTP id 88BB143D83; Mon, 10 Jul 2006 07:41:19 +0000 (GMT) (envelope-from peterjeremy@optushome.com.au) Received: from turion.vk2pj.dyndns.org (c220-239-19-236.belrs4.nsw.optusnet.com.au [220.239.19.236]) by mail27.syd.optusnet.com.au (8.12.11/8.12.11) with ESMTP id k6A7fHv7004906 (version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=NO); Mon, 10 Jul 2006 17:41:17 +1000 Received: from turion.vk2pj.dyndns.org (localhost.vk2pj.dyndns.org [127.0.0.1]) by turion.vk2pj.dyndns.org (8.13.6/8.13.6) with ESMTP id k6A7fHeF000820; Mon, 10 Jul 2006 17:41:17 +1000 (EST) (envelope-from peter@turion.vk2pj.dyndns.org) Received: (from peter@localhost) by turion.vk2pj.dyndns.org (8.13.6/8.13.6/Submit) id k6A7fGos000819; Mon, 10 Jul 2006 17:41:16 +1000 (EST) (envelope-from peter) Date: Mon, 10 Jul 2006 17:41:16 +1000 From: Peter Jeremy To: Mathieu Arnold Message-ID: <20060710074116.GA723@turion.vk2pj.dyndns.org> References: <44B16BE9.60508@rogers.com> <44B171AA.9080400@bitfreak.org> <6C05189234026592B01C2703@[192.168.1.5]> <44B17437.5010506@bitfreak.org> <7215DBE558702ADFC8718798@[192.168.1.5]> <44B176F5.2050409@rogers.com> <2B636EF151DC536C47555034@[192.168.1.5]> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="6TrnltStXW4iwmi0" Content-Disposition: inline In-Reply-To: <2B636EF151DC536C47555034@[192.168.1.5]> X-PGP-Key: http://members.optusnet.com.au/peterjeremy/pubkey.asc User-Agent: Mutt/1.5.11 Cc: Mike Jakubik , 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 07:42:25 -0000 --6TrnltStXW4iwmi0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, 2006-Jul-09 23:45:44 +0200, Mathieu Arnold wrote: >+-Le 09/07/2006 17:36 -0400, Mike Jakubik a dit : >| Exactly, its nice being able to see the current values. How else can i >| see what the values are set to? > >As I previously said, it's 512M on i386, and 1G on 64 bit platforms. That doesn't answer Mike's question. The _default_ i386 size is 512M, the _current_ values can be found using ulimit (getrlimit(2)). Note that on non-PAE i386, the maximum process size is limited by the kernel size - there is a total of 4GB address space available and by default, the kernel has 2GB allocated to it. This isn't quite enough if you have 4GB RAM. --=20 Peter Jeremy --6TrnltStXW4iwmi0 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.4 (FreeBSD) iD8DBQFEsgSc/opHv/APuIcRAt4UAJ9MRExSvJ2TpNiC/dUozUK9ReOTuACgiGur fABvWv9FFDh4gSgI8lgY5kY= =i4kY -----END PGP SIGNATURE----- --6TrnltStXW4iwmi0--