Semi OT: MySQL memory probs...

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?

--
- - - - - - - - - - - - - - - - - - - - - - - -
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