ørret Posted December 13, 2010 Share Posted December 13, 2010 Hello! First of all I made this thread out of curiosity. I have no experience what so ever, and I hope you could help me boost my knowledge a bit :P What are the benefits, and/or disadvantages using SSD for large databases (20+ GB)? If you run a forum on a SSD wouldn't content (posts etc. (not images etc of course)) be displayed much faster (improved speed)? And also, when using the forum search function, wouldn't results display faster? Or am I missing something here? I have read that having DBs on SSD is much more efficient when it comes to repairing/doing changes in the DB and that this on a HDD would take a ridiculous amount of time. I know memory is vital, but let's leave memory out for now. Thanks in advance. Link to comment Share on other sites More sharing options...
Connor T Posted December 13, 2010 Share Posted December 13, 2010 I wondered about SSDs in servers, and I asked my sys admin and he said no. He linked me to this: http://thecoffeedesk...he-data-center/ Guess there just not ready. Link to comment Share on other sites More sharing options...
Ryan H. Posted December 13, 2010 Share Posted December 13, 2010 That article is almost entirely bunk--see Julius's comment below it. Another thing Julius didn't mention, the guy lists fragmentation as a disadvantage--it's irrelevant in a random-access system. As for cost and space, they're somewhat subjective, mostly a matter of purpose. Link to comment Share on other sites More sharing options...
ørret Posted December 13, 2010 Author Share Posted December 13, 2010 Yeah. Reading the comments it seems like they all, or most of them disagree with all the disadvantages that's been put up in the list. I wouldn't use this article as facts. Link to comment Share on other sites More sharing options...
Jaggi Posted December 15, 2010 Share Posted December 15, 2010 The short answer to the whole "Limited write cycles" argument is that no one actually knows yet. SSD are brand new and haven't been out long enough to disapprove or prove this. On paper theres little difference and SSD should run for yrs but this is probably the biggest argument about SSD floating around. I think the real problem with them at the moment is that yes indeed they hella expensive. Link to comment Share on other sites More sharing options...
agent462 Posted December 16, 2010 Share Posted December 16, 2010 Here are just a few articles on the subject. You can search SSD on the site and find more. http://www.mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/ http://www.mysqlperformanceblog.com/2010/07/14/on-benchmarks-on-ssd/ http://www.mysqlperformanceblog.com/2010/01/18/fast-storage-8-ssd-intel-x-25m-80gb-benchmarks/ Link to comment Share on other sites More sharing options...
Lee Craven Posted January 6, 2011 Share Posted January 6, 2011 Not sure why - but this video alone (regardless because the price is through the roof for SSD) keeps my mind at piece, I'm not paying hundreds, even thousands more for SSD for a 1/3 the capacity. It's not worth it! http://www.youtube.com/watch?v=wh81e8diGwc&feature=related Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.