MySQL and default memory limits (mysqld: Out of memory)

[Andras Got]

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.
>