Re:Re: MemSQL the “world's fastest database”? (2012)
by nilsimsa on Thursday October 02, 2014 @01:05AM
(#8399487)
Curious what kind of optimizations you did for SSDs.
[ Parent
| on HN ]
Re:Re: MemSQL the “world's fastest database”? (2012)
by mglukhovsky on Thursday October 02, 2014 @01:19AM
(#8399518)
Here's a few links (from previous HN threads and blog posts) that dive into some of the optimizations we made around SSDs:
* https://news.ycombinator.com/item?id=4795443
* http://www.rethinkdb.com/blog/on-trim-ncq-and-write-amplific...
Re:Re: MemSQL the “world's fastest database”? (2012)
by SamReidHughes on Thursday October 02, 2014 @01:20AM
(#8399520)
The trick involves writing sectors (of size 4K, say, and it can depend on the SSD model) sequentially in aligned blocks (of size 1M, say, but it can depend on the SSD model) so that the SSD firmware that can erase one physical block at a time can handle it efficiently. Especially in 2010.
Re:Re: MemSQL the “world's fastest database”? (2012)
by bayareaguy on Thursday October 02, 2014 @12:48PM
(#8401625)
If you are interested in SSD optimizations you may want to read this research from Microsoft: The Bw-Tree: A B-tree for New Hardware[1]
1 - http://research.microsoft.com/apps/pubs/default.aspx?id=1787...