News for hackers. Stuff that matters.

vasilizo

Re:MySQL is bazillion times faster than MemSQL on Tuesday June 26, 2012 @11:25PM (#4165345)
Chris, MemSQL utilizes versioning to implement READ COMMITTED. In this implementation readers are never blocked.

It is addressed in this FAQ: http://developers.memsql.com/docs/1b/faq.html#c1-q4.

Re:MySQL is bazillion times faster than MemSQL on Tuesday June 26, 2012 @09:24PM (#4165063)
@Nitramp: Fortunately for all of us this world is full of unsolved problems many of which exist outside of consumer web.

There are use cases where 50ms is way too long, and where jitter associated with disk I/O is not acceptable. Capital markets for example. You are looking for sub-millisecond latency to be in the intraday post-trade game, and single digit milliseconds for quote-to-trade. The number of instructions in the hot code path (and cycles per instruction) actually starts to matter. Lock-free sturcutres utilized for storage are also important. This combination gives MemSQL some rather unique low-latency properties that certain folks can exploit to their delight.

To your other point, random reads and key-value lookups is where MemSQL shines. Since you never wait on I/O and don't take locks, optimizing execution makes a lot of sense actually. All that's left is execution and network.

Re:Survey Monkey for the Phone - A Business on Twilio on Tuesday January 12, 2010 @06:11PM (#1048817)
This is great. Graceful and useful tool. Best of luck!