From owner-freebsd-stable Thu Jul 11 5:15:47 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 432E137B400 for ; Thu, 11 Jul 2002 05:15:35 -0700 (PDT) Received: from bunsen.solidcore.dk (bunsen.solidcore.dk [217.116.225.15]) by mx1.FreeBSD.org (Postfix) with ESMTP id 11A5443E09 for ; Thu, 11 Jul 2002 05:15:34 -0700 (PDT) (envelope-from laursen@netgroup.dk) Received: from area51 (gw.oxygen.net [217.116.225.2]) (AUTH: LOGIN laursen@solidcore.dk) by bunsen.solidcore.dk with esmtp; Thu, 11 Jul 2002 14:15:32 +0200 Message-ID: <25f301c228d4$a33d8150$1a01000a@area51> Reply-To: "Lasse Laursen" From: "Lasse Laursen" To: freebsd-stable@freebsd.org Subject: Max. memory amount Date: Thu, 11 Jul 2002 14:14:42 +0200 Organization: NetGroup A/S 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, 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