Mike, > Now the SSD that I would like to have is the Hyperdrive 5 from > http://www.hyperossystems.co.uk/. It is a DDR SSD and each drive has slots > for 8 DIMM's which means it can hold up to 32GB (64GB if you can find 8GB > DDR2's) per drive. They can be striped to give you a heck of a lot of drive > space using RAID. And yes, they are faster than spit and will never wear > out. > > So if I wanted to speed up my MySQL database, I'd definitely be buying quite > a few of these. (Maybe later this year when I've got some cache to > spare<g>) Are these drives expensive? Darn right. Are they worth it? Well, > they say time is money and if you need the results as fast as possible, then > load 'em on up. I find most databases are disk bound and not CPU bound so > switching to ram drives may be the best bang for the buck. :-)
If you're in the Santa Clara area, you might want to hear Mark Callaghan speak on these topics. He recently blogged about it here: http://mysqlha.blogspot.com/2009/04/battle-of-hot-boxes.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org