List:General Discussion« Previous MessageNext Message »
From:mos Date:January 22 2009 8:08pm
Subject:Re: How much memory can mysql 5.1 take advantage of?
View as plain text  
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 to replace a mechanical hard drive. I think it 
would also be good for the actual MySQL data files like on a webserver, not 
just log files. You'd likely want to put updateable tables on a hard drive 
or chron/replicate them to disk storage.

Mike


>-Aaron
>
>On Thu, Jan 22, 2009 at 7:40 AM, mos 
><<mailto:mos99@stripped>mos99@stripped> wrote:
>>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 such as those imposed by 
>>>32-bit processors?
>>>
>>>Thanks!
>>
>>You can get an external ram drive fairly cheap that will handle 32gb per 
>>drive (4gb sticks) and can use raid 0 to give you larger drives. They 
>>cost around $500 for the hardware not including the RAM. On page 9 of the 
>>report 
>><http://techreport.com/articles.x/16255/9>http://techreport.com/articles.x/16255/9
> 
>>they show database and web server performance that blows away all hard 
>>drives by a factor of 10x. They have a small battery backup that will 
>>preserve the contents between reboots and for a few hours during power 
>>loss. An option allows you to back up the contents to flash storage. Of 
>>course you should use a UPS on it. What appeals to me is you can use it 
>>24/7 and it is not going to wear out. This is definitely going on my wish 
>>list. :-)
>>
>><http://techreport.com/articles.x/16255/1>http://techreport.com/articles.x/16255/1
>>
>>Mike
>>
>>--
>>MySQL General Mailing List
>>For list archives:
> <http://lists.mysql.com/mysql>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