Personally, I would not use memsql as a first line RDBMS. It lacks too many useful features, and it doesn't return consistent results for all queries (I've found inconsistencies when using group by with having, for instance).
Why not share a clear example of exactly what happened, or post on their forum with details, so we can all judge for ourselves?