Re: Semi OT: MySQL memory probs...

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Darrin Chandler
Date:  
To: Main PLUG discussion list
Subject: Re: Semi OT: MySQL memory probs...
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
   |  http://phxbug.org/      |  http://metabug.org/
http://www.stilyagin.com/  |  Daemons in the Desert   |  Global BUG Federation
---------------------------------------------------
PLUG-discuss mailing list - 
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss