News for hackers. Stuff that matters.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by snissn on Monday June 18, 2012 @09:10AM (#4126220)
This seems really confusing and like it might be a maintenance nightmare http://developers.memsql.com/docs/1b/memory.html

Do you need to ensure that all of your data fits in memory? It's easily possible to have ten gigs in your db but only need a small amount of it to be hot in ram. Does it take a really long time to restart if it has to warm all the data?

Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by chris_wot on Monday June 18, 2012 @09:22AM (#4126259)
Good questions - no idea! Can one of the developers of MemSQL clarify this? How long does it take to startup a large database of several 100 GB?
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by nikita on Monday June 18, 2012 @09:43AM (#4126350)
Recovery on the system restart is going at the speed of hard disk.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by chris_wot on Monday June 18, 2012 @09:56AM (#4126401)
Can you pin how much data from a table can be placed into memory, or does the whole table need to be placed in memory? I can see settings that limit the transaction log memory usage, but no way of reducing the actual amount of data in-memory.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by nikita on Monday June 18, 2012 @10:19AM (#4126506)
The whole table has to fit in memory. RAM is getting very cheap, you can buy 1Tb for 12K today.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by genwin on Monday June 18, 2012 @05:53PM (#4128792)
But for anyone who is renting the server, it's $$$$ monthly for a fraction of that.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by tintor on Monday June 18, 2012 @03:42PM (#4128119)
Recovery on the system restart is going at the "sequential scan" speed of hard disk.
Re:Ex-Facebookers launch MemSQL (YC W11) to make your databa... by nl on Tuesday June 19, 2012 @02:47AM (#4130555)
The "sequential scan" speed of a generic SSD is pretty good. It's even better on something like FusionIO.