Re: malloc problems with MySQL?

Attila Nagy wrote:
> Hello,
> 
> I have an SMP i386 machine with 2G RAM on which I would like to test 
> MySQL. The OS is CURRENT as of today.
> 
> The problem is that with the exact same configuration as with 6-STABLE, 
> MySQL cannot allocate more than about 400-500MB of memory:
> 
> mysqld: (malloc) Error in malloc(838877200): out of memory
> mysqld got signal 6;
> 
> Limits seems to be OK:
>   datasize          2097152 kB
> I have kern.maxdsiz=2G in loader.conf.
> 
> MySQL gets errno 12 (ENOMEM) when trying to allocate that amount of RAM.
> 
> What else is needed to make it work with the new malloc implementation? 
> I can malloc the same amount of memory from a one liner program...

Allocations that are larger than the chunk size (2 MB by default) are 
allocated using mmap(2), rather than sbrk(2).  Most likely, your 
problems will go away if you reduce the heap size, so that mmap has more 
address space to work with.

Jason