List:General Discussion« Previous MessageNext Message »
From:bmurphy Date:January 22 2009 2:29am
Subject:Re: How much memory can mysql 5.1 take advantage of?
View as plain text  
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.

Keith Murphy


> 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,
> though.
>
> Jake
>
> 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?
>>
>> Thanks!
>>
>>
>> http://www.retailretreat.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


Thread
How much memory can mysql 5.1 take advantage of?webtek2001-mysql20 Jan
  • Re: How much memory can mysql 5.1 take advantage of?Jake Maul22 Jan
    • Re: How much memory can mysql 5.1 take advantage of?bmurphy22 Jan
    • Re: How much memory can mysql 5.1 take advantage of?Luis Motta Campos5 Feb
  • Re: How much memory can mysql 5.1 take advantage of?mos22 Jan
    • Re: How much memory can mysql 5.1 take advantage of?Aaron Blew22 Jan
Re: How much memory can mysql 5.1 take advantage of?mos22 Jan