Thread: SSD database benchmarks
This is the best write-up I've seen yet on quantifying what SSDs are good and bad at in a database context: http://www.bigdbahead.com/?p=37 -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
On 29.04.2008, at 12:55, Greg Smith wrote: > This is the best write-up I've seen yet on quantifying what SSDs are > good and bad at in a database context: > > http://www.bigdbahead.com/?p=37 They totally missed "mainly write" applications which most of my applications are. Reads in a OLTP setup are typically coming from a cache (or, like in our case an index like Solr) while writes go through ... So you might get some decent IO from the SSD when the database just started up without caches filled, but as long as your cache hit ratio is good, it doesn't matter anymore after a couple of minutes. Nevertheless it's an interesting development. cug -- http://www.event-s.net
On Tue, 29 Apr 2008, Guido Neitzer wrote: > They totally missed "mainly write" applications which most of my applications > are. Not totally--the very first graph shows that even on random data, 100% write apps are 1/2 the speed of a regular hard drive. After poking around the site a bit more they also did some tests with MFT, some kernel software from Easy Computing that basically uses a write log disk to improve the write situation: http://www.bigdbahead.com/?p=44 That version also has a better summary of the results. MFT is clearly not ready for prime time yet from the general buginess, but as that approach matures (and more vendors do something similar in hardware) it will be really interesting to see what happens. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
On Tue, Apr 29, 2008 at 2:55 PM, Greg Smith <gsmith@gregsmith.com> wrote: > This is the best write-up I've seen yet on quantifying what SSDs are good > and bad at in a database context: > > http://www.bigdbahead.com/?p=37 > > -- > * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD here is another really informative article (pdf) http://www.storagesearch.com/easyco-flashperformance-art.pdf. The conclusions are different...they claim it's hard to make good use of ssd advantages if you do any random writing at all. Of course, they are also developing an automagical solution to the problem. The information is good though...it's certainly worth a read. The problem is probably solvable. merlin