3 ms·
From MemSQL's home page: "MemSQL writes back to disk/SSD as soon as the transaction is acknowledged in memory." From the article: "See, MemSQL also has “transa
by slewis 14y ago
From MemSQL's home page: "MemSQL writes back to disk/SSD as soon as the transaction is acknowledged in memory."
From the article: "See, MemSQL also has “transaction-buffer” setting, which, in default “full durability mode” will asynchronously return “ok” until 128M buffer is full (or background log flusher thread writes it out)."
So which is it?
- tintor 14y agoIn MemSQL transaction buffer is flushed continuously as long as it is not empty. Default value of 128M is there just to absorb bursts in workload.
- Devilboy 14y agoSo you could lose up to 128MB of updates if the machine crashes at the wrong time. NOT DURABLE.
- aioprisan 14y agomemSQL is NOT durable by design. you can lose the pool of unwritten queries