SSDs for large dbs.

[ørret]

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.

[Connor T]

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.

[Ryan H.]

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.

[ørret]

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.

[Jaggi]

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.

[agent462]

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/

[Lee Craven]

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