From owner-freebsd-stable Thu Jul 11 6:31:29 2002 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 C1EA437B400 for ; Thu, 11 Jul 2002 06:31:22 -0700 (PDT) Received: from hercules.icarz.com (ns1.icarz.com [207.99.22.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id AEA3343E09 for ; Thu, 11 Jul 2002 06:31:21 -0700 (PDT) (envelope-from kenm@icarz.com) Received: from newken (dhcp104.icarz.com [207.99.22.104]) by hercules.icarz.com (8.11.6/8.10.1) with SMTP id g6BDVJG13690; Thu, 11 Jul 2002 09:31:20 -0400 (EDT) Message-ID: <054301c228df$3b8846c0$681663cf@icarz.com> From: "Ken Menzel" To: "Lasse Laursen" , References: <25f301c228d4$a33d8150$1a01000a@area51> Subject: Re: Max. memory amount Date: Thu, 11 Jul 2002 09:31:15 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi Lasse, This question is probably more appropriate for freebsd-questions or the mysql mailing list. Yes, you will want to increase MAXDSIZ and probably DFLDSIZ ex: create a custom kernel (if you have not done so already (see docs)) add this line: options MAXDSIZ="(256*1024*1024)" change it to: options MAXDSIZ="(1024*1024*1024)" set KERNCONF to be your new kernel cd /usr/src;make kernel;shutdown -r NOW and voila! You can now have processes up to 1G. do NOT go above 2047 (1.999999G) or mysql will crash on start, this is a bug in FreeBSD introduced last october when these parameters where made changeable at boot time. BTW you should also be able to change these with the boot loader if you so desire. Best of luck, Ken ----- Original Message ----- From: "Lasse Laursen" To: Sent: Thursday, July 11, 2002 8:14 AM Subject: Max. memory amount > Hi, > > We run a MySQL server on a FreeBSD 4.5 system. There is about 1.5 GByte ram > in the machine and we would ofcause like to use as much as possible for the > MySQL server. When doing a top we get: > > > Mem: 644M Active, 508M Inact, 236M Wired, 38M Cache, 163M Buf, 81M Free > Swap: 2048M Total, 326M Used, 1722M Free, 15% Inuse > > PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND > 99425 mysql 2 0 426M 95344K poll 43.6H 6.20% 6.20% mysqld > 44735 root 28 0 1912K 900K RUN 0:00 25.00% 1.22% top > 129 root 2 0 2144K 856K select 0:58 0.00% 0.00% sshd > > > The MySQL server seems only to use about 500MByte ram? Is there a max. limit > that a process is allowed to use? > > In the LINT file I saw the following: > > > # Certain applications can grow to be larger than the 128M limit > # that FreeBSD initially imposes. Below are some options to > # allow that limit to grow to 256MB, and can be increased further > # with changing the parameters. MAXDSIZ is the maximum that the > # limit can be set to, and the DFLDSIZ is the default value for > # the limit. MAXSSIZ is the maximum that the stack limit can be > # set to. You might want to set the default lower than the max, > # and explicitly set the maximum with a shell command for processes > # that regularly exceed the limit like INND. > # > options MAXDSIZ="(256*1024*1024)" > options MAXSSIZ="(256*1024*1024)" > options DFLDSIZ="(256*1024*1024)" > > > Can we get the MySQL database to use more/all the memory by tweaking on > these parameters? > > > Yours > -- > Lasse Laursen - Systems Developer > NetGroup A/S, St. Kongensgade 40H, DK-1264 København K, Denmark > Phone: +45 3370 1526 - Fax: +45 3313 0066 - Web: www.netgroup.dk > > - We don't surf the net, we make the waves. > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-stable" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message