On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote: > > On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote: > > > I'd be interested to know if you can get a test running that uses > > either a key_buffer or an innodb_buffer_pool in the 3.5GB range. > > Interestingly enough, I can't seem to get MySQL to use more than 2GB of > RAM. > > I get errors like this: > > *** malloc: vm_allocate(size=2042925056) failed with 3 > *** malloc[489]: error: Can't allocate region
Hmm. That's not promising. > I wrote a small C program to test malloc() and see just how much I > could allocate, and I was able to get up to 3.5GB before being cut off > by the OS, which leads me to believe that I should be able to use that > much RAM for MySQL. Yes. I wonder why you got cut off at 3.5GB. I'd have expected OS X on 64bit hardware not to have the weird limitations that, say, FreeBSD or Linux with kernel reserved memory. Something is wonky here... Thanks for the info. I'd love to hear if you're successful getting MySQL to use more than 2GB. I'm gonna hunt around a bit more to see what others may know. Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 32 days, processed 1,219,926,177 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]