From owner-freebsd-stable@FreeBSD.ORG Sun Jul 9 21:54:38 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 B5A5716A4DE; Sun, 9 Jul 2006 21:54:38 +0000 (UTC) (envelope-from stephen@math.missouri.edu) Received: from sccmmhc92.asp.att.net (sccmmhc92.asp.att.net [204.127.203.212]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3A06E43D53; Sun, 9 Jul 2006 21:54:38 +0000 (GMT) (envelope-from stephen@math.missouri.edu) Received: from [10.0.0.4] (12-216-254-44.client.mchsi.com[12.216.254.44]) by sccmmhc92.asp.att.net (sccmmhc92) with ESMTP id <20060709215432m92002rm95e>; Sun, 9 Jul 2006 21:54:36 +0000 Message-ID: <44B17B18.8070906@math.missouri.edu> Date: Sun, 09 Jul 2006 16:54:32 -0500 From: Stephen Montgomery-Smith User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.13) Gecko/20060707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mike Jakubik 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> In-Reply-To: <44B176F5.2050409@rogers.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: Mathieu Arnold , Darren Pilgrim , 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:54:38 -0000 Mike Jakubik wrote: > Mathieu Arnold wrote: > >> +-Le 09/07/2006 14:25 -0700, Darren Pilgrim a dit : >> | Mathieu Arnold wrote: >> |> [kern.maxdsiz is not] a sysctl, it's a tunable thing, which don't >> |> appear in sysctl. >> | | Gotta love namespace collisions. >> >> Well, in fact, most of the tunables do have a read only sysctl so that >> people don't have to search the code for the value it has/takes :-) >> Not this one though :-) >> > > > Exactly, its nice being able to see the current values. How else can i > see what the values are set to? The commands limit and limits (one of them is a csh only command) will tell you (although they might be set lower for a particular user via /etc/login.conf, or for a particular process, but that's unlikely). Stephen