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:mo...@fastmail.fm>mo...@fastmail.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>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=aaronb...@gmail.com>http://lists.mysql.com/mysql?unsub=aaronb...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org