Try lowering indicated value some...


On Mon, 2008-01-28 at 10:38 -0800, Randy Melder wrote:
> [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@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@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@lists.plug.phoenix.az.us
> > To subscribe, unsubscribe, or to change your mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
> 
> 
> 

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss