Book a Demo
Learn about the MemSQL database and its capabilities
ETL in real-time
Manage and Monitor
With powerful tooling
Frequently asked questions
Move to Cloud
Internet of Things
Secure Govt Data
From basic FAQs to in-depth tech docs.
6.8 Release Notes
How MemSQL Works
A Technical Introduction to MemSQL
John Sherwood, a senior engineer at MemSQL on the query optimizer team, presented at MemSQL’s Engineering Open House in our Seattle offices last month. He gave a technical introduction to the MemSQL database, including its support for in-memory rowstore tables and disk-backed columnstore tables, its SQL support and MySQL wire protocol compatibility, and how aggregator and leaf nodes interact to store data and answer queries simultaneously, scalably, and with low latencies. He also went into detail about code generation for queries and query execution. Following is a lightly edited transcript of John’s talk. – Ed. This is a brief technical …
Case Study: Fraud Detection “On the Swipe” For a Major …
This case study was originally presented as part of a webinar session by Mike Boyarski, Sr. Director of Product Marketing at MemSQL. It’s been updated to include additional information and references. In the webinar, which you can view here, and access the slides here, Mike describes the challenges facing financial services institutions which have decades’ worth of accumulated technology solutions – and which need to evolve their infrastructure immediately to meet today’s needs. In this case study, which was also described in the webinar, Mike shows how a major US bank created a new streaming data architecture with MemSQL at …
Webinar: Real-Time Fraud Detection for an Improved User …
In this webinar, which you can view here, MemSQL’s Mike Boyarski describes how real-time fraud detection represents a major digital initiative for banks. He shows how MemSQL gives fraud detection services, along with other real-time analytics, an edge with faster ingest, real-time scoring, and rapid response to a broader set of events. He also describes a major US bank’s implementation of this approach, which is described separately in our case study about fraud detection on the swipe. This webinar was originally presented as part of our webinar series, How Data Innovation is Transforming Banking (click the link to access the …
An Intro to MemSQL
A 30-minute webinar to understand how it works
Configuration Reference Overview
List of Engine Variables
MemSQL Tools Reference
MemSQL And Spark
MemSQL Ops CLI Reference
: Overrides the default settings for the entire system.
: Contains information about MemSQL nodes that exist on that host.
We're always happy to help with code or other questions you might have!
Search our documentation
, check out the
, visit our
MemSQL Community Forum
for enterprise support.
Was this article useful?
Sorry about that
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or feedback
Email (if you'd like us to respond to you)