Semi OT: MySQL memory probs...

[Darrin Chandler]

On Mon, Jan 28, 2008 at 09:57:09AM -0800, Randy Melder wrote:
> Group,
> 
> Got a problem with a client's MySQL server. It's an OS X tiger server w/2 intel
> cpu, 8gb RAM, 80GB hdd (70% used). It's got 128mb free memory. When
> MySQL gets a large query, it gets memory allocation errors. Binary and
> error logging are turned on.
> 
> After a lot of googling... it appears that the MySQL binary for OS X
> is 32bit and has an allocation limit of 2gb. I dunno if that is our
> probe here.
> 
<SNIP>
> Error logs:
> mysqld(380,0x1975800) malloc: *** vm_allocate(size=209715200) failed
> (error code=3)
> mysqld(380,0x1975800) malloc: *** error: can't allocate region
> mysqld(380,0x1975800) malloc: *** set a breakpoint in szone_error to debug
> mysqld(380,0x1975800) malloc: *** vm_allocate(size=157286400) failed

Do you have a my.cnf configuration file with sane values? Perhaps
lowering some of the *_size values to reflect actual limits will help.
I'm guessing that mysql thinks it can get more than it really can, and
that's the source of the problem. Perhaps Googling for "my.cnf osx" will
help...

-- 
Darrin Chandler            |  Phoenix BSD User Group  |  MetaBUG
dwchandler at stilyagin.com   |  http://phxbug.org/      |  http://metabug.org/
http://www.stilyagin.com/  |  Daemons in the Desert   |  Global BUG Federation