From owner-freebsd-stable@FreeBSD.ORG Sun Jul 9 21:17:08 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 5CEB116A4DA; Sun, 9 Jul 2006 21:17:08 +0000 (UTC) (envelope-from mat@FreeBSD.org) Received: from plouf.absolight.net (plouf.absolight.net [193.30.224.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id EA99D43D6D; Sun, 9 Jul 2006 21:17:07 +0000 (GMT) (envelope-from mat@FreeBSD.org) Received: from pouet.in.mat.cc (pouet.in.mat.cc [193.30.224.122]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by plouf.absolight.net (Postfix) with ESMTP id F03B74FF633; Sun, 9 Jul 2006 23:17:06 +0200 (CEST) Date: Sun, 09 Jul 2006 23:17:05 +0200 From: Mathieu Arnold To: Darren Pilgrim , Mathieu Arnold Message-ID: <6C05189234026592B01C2703@[192.168.1.5]> In-Reply-To: <44B171AA.9080400@bitfreak.org> References: <44B16BE9.60508@rogers.com> <44B171AA.9080400@bitfreak.org> X-Mailer: Mulberry/4.0.4 (Win32) MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="==========3AEF3F46EB7D8CD9A4E3==========" 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: Sun, 09 Jul 2006 21:17:08 -0000 --==========3AEF3F46EB7D8CD9A4E3========== Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline +-Le 09/07/2006 14:14 -0700, Darren Pilgrim a dit : | Mathieu Arnold wrote: |> +-Le 09/07/2006 16:49 -0400, Mike Jakubik a dit : | > | 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. | | That OID doesn't seem to exist: | | > uname -pr | 6.0-RELEASE-p1 i386 | > sysctl -N kern | grep max That's not a sysctl, it's a tunable thing, which don't appear in sysctl. -- Mathieu Arnold --==========3AEF3F46EB7D8CD9A4E3========== Content-Type: application/pgp-signature Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) iD8DBQFEsXJRJqR8av5thQ8RAmmsAJ4iFMQ+UwQ2eL6WkpgYuxYjPHN8FwCgtIyP /lKF7BWbiBNjAUBghjrnR84= =OldM -----END PGP SIGNATURE----- --==========3AEF3F46EB7D8CD9A4E3==========--