Re: Semi OT: MySQL memory probs...

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Craig White
Date:  
To: Main PLUG discussion list
Subject: Re: Semi OT: MySQL memory probs...

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 -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss