From: Aaron Blew (aaronblewgmail.com)
Date: Thu Jan 22 2009 - 09:57:48 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <mos99fastmail.fm> 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 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
>
> Mike
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=aaronblewgmail.com
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]