News for hackers. Stuff that matters.
Re:MySQL is bazillion times faster than MemSQL by mikeash on Tuesday June 26, 2012 @12:29PM (#4162745)
I thought his main criticism was that MemSQL isn't durable by default, and that when you enable that it becomes incredibly slow. That's a pretty big deal, and IMO running database benchmarks on an unsafe configuration like this is extremely dishonest.
Re:MySQL is bazillion times faster than MemSQL by ericfrenkiel on Tuesday June 26, 2012 @12:35PM (#4162777)
That's a bit heavy-handed; additional benchmarks will be published against a variety of configurations and other databases.

Companies use MemSQL because it uses memory as the primary locus of data. If you have a fast data problem, you couldn't use a disk-based system. At high speeds, you'd want to deploy any database in an active-active mode.

Re:MySQL is bazillion times faster than MemSQL by merlincorey on Tuesday June 26, 2012 @01:34PM (#4163086)
I just want to echo mike above with a slightly different tact that perhaps will get across my perception of our feelings.

It's dishonest, at the very least, to claim ACID compliance and then do benchmarks against a known ACID compliant competitor without having the same level of ACIDity enabled in your program.

If you want to prove how fast MemSQL is against MongoDB, that's one thing (I understand it also can be "fully durable" but it is not by default due to speed concerns). To prove how fast MemSQL is against MySQL, you have to prove it on the same playing field, which means it has to, necessarily, be just as ACIDic and respond to "real" queries on large datasets with high concurrency.

tl;dr Do some benchmarks of apples-to-apples ACID, and do something about the common case of a head of a table, then you will be honestly faster (or not) than MySQL

Re:MySQL is bazillion times faster than MemSQL by pork on Tuesday June 26, 2012 @03:19PM (#4163668)
> (I understand it also can be "fully durable" but it is not by default due to speed concerns)

Just a little addendum: MongoDB has been "durable by default" since v1.7 I believe (current: 2.0.6).

Re:MySQL is bazillion times faster than MemSQL by jhugg on Tuesday June 26, 2012 @03:34PM (#4163735)
Since 2.0, the journal is enabled. It flushes to disk every 100ms. Operations can return successfully without writing the data to disk. This is similar to what MemSQL is offering by default.
Re:MySQL is bazillion times faster than MemSQL by shin_lao on Tuesday June 26, 2012 @01:15PM (#4162991)
Then you cannot claim you're ACID, since the D stands for durable. Something is wrong with your marketing.
Re:MySQL is bazillion times faster than MemSQL by mikeash on Tuesday June 26, 2012 @12:38PM (#4162795)
How is it heavy handed? As I understand the article, MemSQL by default will often say that a transaction has been committed even though it only exists in memory, not on disk. Comparing that scenario with a MySQL setup which only says a transaction has been committed once it's on non-volatile storage is just wrong.
Re:MySQL is bazillion times faster than MemSQL by aioprisan on Tuesday June 26, 2012 @07:07PM (#4164653)
then your marketing is bullshit, claiming durability when you know that's not what you're doing with memsql. talk about wasting people's time with claims of 30x speedup, laughable