At work they bought us all SSDs and we migrated over (just our operating systems / core files, etc). Since moving my Ubuntu Precise OS to an SSD I have noticed a dramatic performance increase... (I run test websites from my local Ubuntu Precise box).
I've been working on a data warehouse project with 20 million records / 10 gigs -- I probably got my work done several times faster since the SSD was able to quickly do things like add index / or import data, etc. I indexed things well (by the way, adding indexes on a large database is slow & painful) -- and it's reasonably fast to query the little data-warehouse with relatively complex queries (I did a star schema with a fact table & dimension tables). Another example; the database from our main site is fairly large (300 megs-- far smaller than the 10 gig data warehouse) and with my old SATA HD it took about 30 minutes to import. With the SSD it takes less than 3 minutes to import. -that's a factor of 10 improvement on write speed (SSD vs HD SATA) -read speed seems to be improved on a more exponential scale (100x?) Depending on the kind of work you're doing an SSD can make a pretty huge difference... At least where I work our new SSD Drives have helped us become a bit more productive. -Jason On Mon, Oct 1, 2012 at 10:26 AM, Steve Meyers <[email protected]>wrote: > On 10/1/12 10:24 AM, Joseph Scott wrote: > > More or less what Justin said. A large number of the WordPress.com > > MySQL backends now use SSD, we found the increased performance more > > than offset the increase in price. Though many of our DB servers were > > maxing out on I/O, if you find that you aren't I/O bound currently > > then the impact could be much smaller. > > This is especially true if your data set fits in memory. Of course, if > it doesn't, then you're probably I/O bound. :) > > Steve > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net > _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
