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>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] Valentin Bud wrote: > > 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="YES" to /etc/rc.conf and the server start with removed limits. You can increase maxdsiz (which is different than limits) by adding a line to loader.conf, something like: kern.maxdsiz=2GB kern.dfldsiz=2GB 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). [-- Attachment #2 --] -----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-----help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?gmsbnq$dce$1>