Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
chris_wot
on June 18, 2012
|
parent
|
context
|
favorite
| on:
Ex-Facebookers launch MemSQL (YC W11) to make your...
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.
nikita
on June 18, 2012
[–]
The whole table has to fit in memory. RAM is getting very cheap, you can buy 1Tb for 12K today.
genwin
on June 18, 2012
|
parent
|
next
[–]
But for anyone who is renting the server, it's $$$$ monthly for a fraction of that.
tintor
on June 18, 2012
|
parent
|
prev
[–]
Recovery on the system restart is going at the "sequential scan" speed of hard disk.
nl
on June 19, 2012
|
root
|
parent
[–]
The "sequential scan" speed of a generic SSD is pretty good. It's even better on something like FusionIO.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
