News for hackers. Stuff that matters.
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.