Re: How much memory can mysql 5.1 take advantage of?

2009-02-05 Thread Luis Motta Campos
Jake Maul wrote: 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

Re: How much memory can mysql 5.1 take advantage of?

2009-01-22 Thread mos
At 01:08 PM 1/20/2009, you 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

Re: How much memory can mysql 5.1 take advantage of?

2009-01-22 Thread Aaron Blew
This doesn't work the same way as system RAM though. You can't extend your innodb buffer pool onto a block device or filesystem. Though this technology would be good for segregating things like InnoDB logs and mysql binary logs. -Aaron On Thu, Jan 22, 2009 at 7:40 AM, mos mo...@fastmail.fm

Re: How much memory can mysql 5.1 take advantage of?

2009-01-22 Thread mos
At 09:57 AM 1/22/2009, you wrote: This doesn't work the same way as system RAM though. You can't extend your innodb buffer pool onto a block device or filesystem. Though this technology would be good for segregating things like InnoDB logs and mysql binary logs. Of course. This device is

Re: How much memory can mysql 5.1 take advantage of?

2009-01-21 Thread Jake Maul
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

Re: How much memory can mysql 5.1 take advantage of?

2009-01-21 Thread bmurphy
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

How much memory can mysql 5.1 take advantage of?

2009-01-20 Thread webtek2001-mysql
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