High-Performance for OLTP and OLAP Workloads
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
SingleStore is a highly-scalable distributed system.
SingleStore also supports storing and processing data using an in-memory rowstore or a disk-based columnstore.
Columnstores are the default table type, but rowstores can be created by specifying a rowstore index type.
In addition to handling mixed workloads, SingleStore supports high concurrency for simultaneous users.
Multi-Version Concurrency Control (MVCC)
SingleStore uses Multi-Version Concurrency Control (MVCC) to support high concurrency, which allows simultaneous reads and writes without blocking.UPDATE
query is run, SingleStore creates a new version of the rows to be updated, while the old version remains accessible to transactions that began before the UPDATE
.SELECT
queries without waiting for write operations to finish.SELECT
and UPDATE
) that need access to the old version have completed.
For more information, refer to:
Last modified: November 27, 2024