On 10/2/09 16:58, Ivan Voras wrote: > 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). > > I'd highly recommend databases/mysqltuner if only because it will tell you the maximum possible memory your config will use (as well as sensible config recommendations.)
Vince _______________________________________________ firstname.lastname@example.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"