News for hackers. Stuff that matters.
Re:MemSQL is now free to use for databases with up to 128GB ... by ruw1090 on Tuesday November 06, 2018 @12:16PM (#18392898)
The best thing to do in this situation would be to set the maximum memory on the MemSQL server via the `maximum_memory` system variable. The server will then internally manage it's memory usage against this upper bound and fail only specific operations which can't be performed without additional memory.
Re:MemSQL is now free to use for databases with up to 128GB ... by polskibus on Tuesday November 06, 2018 @12:43PM (#18393158)
What are the specific operations? Will another batch of INSERTs / UPDATEs work? Does it matter if I use the analytical part of MemSQL ?
Re:MemSQL is now free to use for databases with up to 128GB ... by ruw1090 on Tuesday November 06, 2018 @01:56PM (#18393868)
I mean that an operation that needs more memory than is available will fail, but the server itself will remain operational. An simple example would be loading more data into an in-memory table (row store) than there is available memory. If you're using the columnstore then your storage won't be limited to memory.
Re:MemSQL is now free to use for databases with up to 128GB ... by polskibus on Tuesday November 06, 2018 @02:29PM (#18394158)
That sucks, it's similar to Hekaton though. I was hoping there was some kind of a fallback mode when the DB has to juggle memory buffers at a performance cost.