From owner-freebsd-questions@FreeBSD.ORG Tue Feb 10 16:58:52 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 646EE106566B for ; Tue, 10 Feb 2009 16:58:52 +0000 (UTC) (envelope-from freebsd-questions@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id E1BBE8FC08 for ; Tue, 10 Feb 2009 16:58:51 +0000 (UTC) (envelope-from freebsd-questions@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1LWvwd-0005W0-TN for freebsd-questions@freebsd.org; Tue, 10 Feb 2009 16:58:47 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 10 Feb 2009 16:58:47 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 10 Feb 2009 16:58:47 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-questions@freebsd.org From: Ivan Voras Date: Tue, 10 Feb 2009 17:58:31 +0100 Lines: 49 Message-ID: References: <139b44430902100849r30b5144cxb5770fa45fa6c906@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigDB3FECBC91B0A3FF2D5C3C19" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.19 (X11/20090105) In-Reply-To: <139b44430902100849r30b5144cxb5770fa45fa6c906@mail.gmail.com> X-Enigmail-Version: 0.95.0 Sender: news Subject: Re: mysqld out of memory X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Feb 2009 16:58:52 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigDB3FECBC91B0A3FF2D5C3C19 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Valentin Bud wrote: >=20 > I noticed that it is already at 1GB. Now my problem is how can i avoid = this > in the future because > on that production server mysql is crucial or in case it happens how ca= I be > the first to know > of that problem? If you examine the mysql-server script in /usr/local/etc/rc.d you'll see it supports the "mysql_limits" option for rc.conf. Set mysql_limits=3D"YES" to /etc/rc.conf and the server start with removed li= mits. You can increase maxdsiz (which is different than limits) by adding a line to loader.conf, something like: kern.maxdsiz=3D2GB kern.dfldsiz=3D2GB Note that you can't increase it to more than 3 GB on i386. Another thing is that mysql shouldn't take infinite amounts of memory to work. You need to configure entries in my.cnf to match your limits and maxdsiz (in steady state + estimated spikes). --------------enigDB3FECBC91B0A3FF2D5C3C19 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJkbI3ldnAQVacBcgRAnRHAKCRugpoX/KP+92guKOxYO5gnH6FYgCeKi3h jmc9JxEdo1jwwxiGxM/efIs= =ykFr -----END PGP SIGNATURE----- --------------enigDB3FECBC91B0A3FF2D5C3C19--