Semi OT: MySQL memory probs...

[Randy Melder]

[mysqld]
log-bin=/usr/local/mysql_binlogs/auca-sql01m
max_binlog_size=10240M
server-id=1
default-storage-engine=innodb
innodb_flush_log_at_trx_commit=1
sync_binlog=1
key_buffer_size=2000M
sort_buffer_size=200M
innodb_buffer_pool_size=200M
read_buffer_size=50M
innodb_log_buffer_size=8M


On Jan 28, 2008 10:23 AM, Darrin Chandler <dwchandler at stilyagin.com> wrote:
> 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
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>



-- 
- - - - - - - - - - - - - - - - - - - - - - - -
randymelder at gmail.com

NOTICE: The information contained in this e-mail is confidential and
is for the use only of the intended recipient. If you are not the
intended recipient, any disclosure, copy, distribution or other use of
this information is prohibited. If you have received this
communication in error please notify us immediately by telephone and
delete or discard this message immediately.