From owner-freebsd-database@FreeBSD.ORG  Wed Nov 26 11:32:39 2003
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 4FA7D16A4CE
	for <freebsd-database@freebsd.org>;
	Wed, 26 Nov 2003 11:32:39 -0800 (PST)
Received: from eldritch.valis.net.pl (valis.net.pl [80.55.59.218])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 2BF4743F85
	for <freebsd-database@freebsd.org>;
	Wed, 26 Nov 2003 11:32:32 -0800 (PST)	(envelope-from ex@valis.net.pl)
Received: from localhost (localhost [127.0.0.1])
	by eldritch.valis.net.pl (Postfix) with ESMTP id 50EB3FCDD
	for <freebsd-database@freebsd.org>;
	Wed, 26 Nov 2003 20:36:03 +0100 (CET)
Received: from eldritch.valis.net.pl ([127.0.0.1])
	by localhost (eldritch [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 07929-06 for <freebsd-database@freebsd.org>;
	Wed, 26 Nov 2003 20:35:55 +0100 (CET)
Received: by eldritch.valis.net.pl (Postfix, from userid 0)
	id E36C7FCDA; Wed, 26 Nov 2003 20:35:54 +0100 (CET)
Received: from ex-home (localhost [127.0.0.1])
	by eldritch.valis.net.pl (Postfix) with ESMTP id C22383B2AF
	for <freebsd-database@freebsd.org>;
	Wed, 26 Nov 2003 20:35:54 +0100 (CET)
Date: Wed, 26 Nov 2003 20:32:33 +0100
From: Tomasz Szymczak <ex@valis.net.pl>
To: freebsd-database@freebsd.org
Message-Id: <20031126203233.42f4ca6c.ex@valis.net.pl>
In-Reply-To: <20031126120308.R414@pcle2.cc.univie.ac.at>
References: <20031126120308.R414@pcle2.cc.univie.ac.at>
X-Mailer: Sylpheed version 0.9.6claws (GTK+ 1.2.10; i386-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new-20030616-p5 (Debian) at valis.net.pl
Subject: Re: MySQL tuning
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 26 Nov 2003 19:32:39 -0000

On Wed, 26 Nov 2003 12:13:30 +0100 (CET)
Lukas Ertl <l.ertl@univie.ac.at> wrote:

> According to top, mysqld uses 515M RAM (148M RSS), and there's plenty of
> RAM free (or rather, 'inactive').
>=20
> Any ideas, hints, tips?

Try add following to kernel configuration:

options         MAXDSIZ=3D"(2048*1024*1024)"
options         DFLDSIZ=3D"(2048*1024*1024)"

--=20
Tomasz Szymczak                                                    _.-.  jgs
GCS/M d- s-:- a-- C+++$ UL++$>++++$ P++ L++>++++ E W++ N+ w O+   '( ^{_}   =
 (
PS+ PE !Y PGP+ t- X- R tv-- b++>+++ DI D>+++ G e>++++ h! r- y?     `~\`----=
-'\
Umys=B3 sprawia, =BFe wszystko si=EA zmienia, =BFeby upozorowa=E6 up=B3yw c=
zasu   )_)---)_)