Product Solutions Support
Try MemSQL

6.0 Release Notes

MemSQL 6.0 includes enhancements to query processing with up to 80X performance improvement for group-by/aggregate queries, and broader SQL support. It also introduces extensibility features, and enhanced manageability and resiliency.

MemSQL 6.0 contains the following new capabilities:

Extensibility

MemSQL 6 introduces extensibility features as part of the new MemSQL Procedural SQL (MPSQL) language. MemSQL developers can create user-defined:

SPs, UDFs, and UDAFs are compiled to machine code for high performance. Array and record types are supported in SPs and UDFs. SPs and UDFs also support exception handling. The MPSQL language will be familiar and straightforward to learn for database developers who have written functions and stored procedures in other database languages.

Query Processing

Query Language Features

The following new query language features are included in the release:

Query Optimization

Query Execution

Query execution improvements include:

Columnstore

Improvements to the columnstore include:

Data Loading

Data loading enhancements include:

Manageability and Resiliency

Manageability and resiliency has been improved for the 6.0 release, including:

Benefits include fewer situations that require manual intervention, simplified application development, and improved availability.

Maintenance Release Changelog

2017-11-15 Version 6.0.9 (LATEST)

2017-11-07 Version 6.0.8

2017-10-25 Version 6.0.7

Related Topics

Was this article useful?