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.
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?