Date: Tue, 10 Feb 2009 17:58:31 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-questions@freebsd.org Subject: Re: mysqld out of memory Message-ID: <gmsbnq$dce$1@ger.gmane.org> In-Reply-To: <139b44430902100849r30b5144cxb5770fa45fa6c906@mail.gmail.com> References: <139b44430902100849r30b5144cxb5770fa45fa6c906@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?gmsbnq$dce$1>