I have seen testing of servers up to 128 GB of RAM. I wish I could say I
was the one doing the test..however I use systems on a regular basis with
up to 32 GB. Does it scale perfectly? No. Is it better than it was just a
year ago even? Definitely.
Hope that helps.
> Didn't want this to go unanswered, although I don't have any great info
> for you.
> As long as you're running a 64-bit OS and a 64-bit version of MySQL,
> there's no technical reason it would be limited to less than the
> addressable space (that I know of). The main gain would be the ability
> to set larger buffers and handle more connections simultaneously. Of
> course, this is assuming your queries and schema are good and you
> don't suffer from excessive locking problems.
> That is to say... yes, it'll work, and yes, as far as I know MySQL
> will be able to allocate as much RAM as you can stuff in the box.
> Whether it can use it *effectively* is something I don't have any
> experience with beyond ~8GB. I suspect it would work just fine,
> On Tue, Jan 20, 2009 at 12:08 PM, <webtek2001-mysql@stripped> wrote:
>> While specing out a new server, I was wondering if there is any limit to
>> how much memory can be allocated to mysql 5.1. If a server has 16GB of
>> ram, can mysql take advantage of that much ram (minus a reserved amount
>> for the OS obviously)? Is there any limit such as those imposed by
>> 32-bit processors?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: