[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 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. > > > > > 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 > -- - - - - - - - - - - - - - - - - - - - - - - - - randymelder@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. --------------------------------------------------- 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