Date: Thu, 11 Jul 2002 14:14:42 +0200 From: "Lasse Laursen" <laursen@netgroup.dk> To: freebsd-stable@freebsd.org Subject: Max. memory amount Message-ID: <25f301c228d4$a33d8150$1a01000a@area51>
next in thread | raw e-mail | index | archive | help
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: <SNIP> 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 <SNIP> 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: <SNIP> # 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)" <SNIP> Can we get the MySQL database to use more/all the memory by tweaking on these parameters? Yours -- Lasse Laursen <laursen@netgroup.dk> - 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?25f301c228d4$a33d8150$1a01000a>