Semi OT: MySQL memory probs...

[Craig White]

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