On Mon, 2008-01-28 at 09:57 -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.
>
> Details:
> mysql Ver 14.14 Distrib 5.1.22-rc, for apple-darwin8.5.1 (i686) using
> readline 5.0
> Model Name: Xserve
> Model Identifier: Xserve1,1
> Processor Name: Dual-Core Intel Xeon
> Processor Speed: 2.66 GHz
> Number Of Processors: 2
> Total Number Of Cores: 4
> L2 Cache (per processor): 4 MB
> Memory: 8 GB
> Bus Speed: 1.33 GHz
> Boot ROM Version: XS11.0080.B00
> SMC Version: 1.11f5
> LOM Revision: 1.2.7
>
> 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
> (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,0x1f5ec00) malloc: *** vm_allocate(size=209715200) failed
> (error code=3)
> mysqld(380,0x1f5ec00) malloc: *** error: can't allocate region
> mysqld(380,0x1f5ec00) malloc: *** set a breakpoint in szone_error to debug
> mysqld(380,0x1f5ec00) malloc: *** vm_allocate(size=157286400) failed
> (error code=3)
> mysqld(380,0x1f5ec00) malloc: *** error: can't allocate region
> mysqld(380,0x1f5ec00) malloc: *** set a breakpoint in szone_error to debug
> mysqld(380,0x1ccc400) malloc: *** vm_allocate(size=209715200) failed
> (error code=3)
> mysqld(380,0x1ccc400) malloc: *** error: can't allocate region
> mysqld(380,0x1ccc400) malloc: *** set a breakpoint in szone_error to debug
> mysqld(380,0x1ccc400) malloc: *** vm_allocate(size=157286400) failed
> (error code=3)
> mysqld(380,0x1ccc400) malloc: *** error: can't allocate region
> mysqld(380,0x1ccc400) malloc: *** set a breakpoint in szone_error to debug
>
> Thoughts?
----
btw...a bit pricey but I just got an e-mail, MySQL database
administrator class coming to Salt Lake City March 17-21
http://www.mysql.com/training/workshops/mysql_dba.html
and high availability in Phoenix Feb 18-20
http://www.mysql.com/training/courses/mysql_5_ha.html
Craig
---------------------------------------------------
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
(text/plain)