Date: Mon, 10 Jul 2006 18:14:08 +0200 From: Andras Got <andrej@antiszoc.hu> To: stable@freebsd.org Cc: Mike Jakubik <mikej@rogers.com> Subject: Re: MySQL and default memory limits (mysqld: Out of memory) Message-ID: <44B27CD0.3050701@antiszoc.hu> In-Reply-To: <44B276F7.4070507@mac.com> References: <44B16BE9.60508@rogers.com> <E56FEA0F58A776685B3AB5DF@[192.168.1.5]> <44B176D2.3080501@rogers.com> <44B276F7.4070507@mac.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, IMHO on servers 2G is common these these days, and 4G will be common very soon. As people use the websites and the internet more, the needed resources are growing fast. This 512MB will be soon revised imho. :) For example I run a little hosting server for my company and 2 years ago a 2,4Ghz xeon was more than enough. This year I had to replace that machine with an X2100 with 2G RAM because of the customer needs. The number of the pages hadn't grown significally, just the number of served pages and of course the mysql databases. Andras Chuck Swiger wrote: > Mike Jakubik wrote: > [ ... ] >> Why are the limits so low by default? In any case, this is what i >> found in LINT. >> >> options MAXDSIZ=(1024UL*1024*1024) >> options MAXSSIZ=(128UL*1024*1024) >> options DFLDSIZ=(1024UL*1024*1024) >> >> I have no idea what those values mean, what should i set them to to be >> safe? A limit 768MB should work for me. > > 512MB is more than enough for almost all processes to run just fine, and > is only really inappropriate for the case where you've got 1-plus GB of > physical RAM and want to dedicate the system to a single large task, or > perhaps a single-digit number of processes if you've got several GB of > physical RAM. >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44B27CD0.3050701>