The following table briefly compares the various features of the openGauss disk-based storage engine and the MOT storage engine.
Table 1 Comparison – Disk-based vs. MOT
Feature
openGauss
Disk Store
openGauss
MOT Engine
Intel x86 + Kunpeng ARM
Yes
Yes
SQL and Feature-set Coverage
100%
98%
Scale-up (Many-cores, NUMA)
Low Efficiency
High Efficiency
Throughput
High
Extremely High
Latency
Low
Extremely Low
Distributed (Cluster Mode)
Yes
Yes
Isolation Levels
READ COMMITTED
REPEATABLE READ
READ COMMITTED
REPEATABLE READ
Concurrency Control
Pessimistic + MVCC
Optimistic + MVCC
Data Capacity (Data + Index)
Unlimited
Limited to DRAM
Native Compilation
No
Yes
Query (by PREPARE command)
Stored Procedures (by PREPARE command)
Replication, Recovery
Yes
Yes
Replication Options
2 (sync, async)
3 (sync, async, group-commit)
Top comments (0)