Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.0

...

The following chart summarizes the differences between In-Memory and persistent tables.

Physical Properties

In-MemoryPersistent Storage Comparison

Storage

In-Memory (exclusively)On disk (exclusively)

Row Size Limit

32K (enforced on INSERT/UPDATE)64MB (enforced on INSERT/UPDATE)

Container Structure (data and indices)

skiplistlayered, btree

ClustrixDB Compatibility

In-MemoryPersistent Storage Comparison

Standard SQL DDL and DML Interface

YesYes

MVCC

Optimistic MVCCMVCC

Row Locking/Latches

NoYes

Sliced

YesYes

Replicated

YesYes

Distributed/Balanced Cluster-wide

YesYes

Fault Tolerant (if you lose a node, ClustrixDB reprotects)

Yes
NoYes

Join In-Memory tables and persistent tables

YesYes

Foreign Key Support

YesYes

Utilizes Sierra Query Planner and Execution

YesYes

Views

YesYes

Indexes

YesYes

Triggers

YesYes

Stored Procedures

YesYes

Partitioned Tables

YesYes

Temporary Tables

YesYes

ACID Compliance

In-MemoryPersistent Storage Comparison

Atomic, Consistent, and Isolated transactions cluster-wide

YesYes

Durable data and transactions

NoYes

Utilities/Other

In-MemoryPersistent Storage Comparison

clustrix_import

YesYes
load_data_infile

LOAD DATA INFILE

YesYes

Backup

/

and Restore

YesYes

mysqldump

YesYes

Replication

YesYes

Online Schema Changes

YesYes

Caveats and Limitations of In-Memory Tables

...