Checkpoints

Consistent Fuzzy

XtraDB, a fork of InnoDB, is the default storage engine of MariaDB 10.1, while InnoDB is the default storage engine of MariaDB 10.2. InnoDB supports: Sharp checkpointing: all dirty pages of committed transactions are being flushed, while dirty pages for uncommitted transactions are not being flushed. Fuzzy checkpointing: the dirty pages that will be flushed in sharp checkpointing will be gradually flushed.

Concurrency Control

Two-Phase Locking (Deadlock Detection)

InnoDB uses 2PL deadlock detection.

Data Model

Relational

Foreign Keys

Supported

MariaDB requires foreign keys to be checked that some integrity rules are enforced.

Indexes

B+Tree Hash Table

Different Storage engines support different indexes: Aria: B-tree, R-tree MyISAM B-tree, R-tree InnoDB: B-tree Memory/Heap: Hash, B-tree *NDB: B-tree, Hash

Isolation Levels

Read Uncommitted Read Committed Serializable Repeatable Read

Joins

Nested Loop Join Hash Join Sort-Merge Join

Logging

Logical Logging Physical Logging

Physical logging is called binary logging in MariaDB, while logical logging is called general query logging.

Query Compilation

Not Supported

Query Interface

Custom API SQL Stored Procedures

Storage Architecture

Disk-oriented In-Memory

MariaDB supports different storage architectures with different storage engines.

Storage Model

Decomposition Storage Model (Columnar) N-ary Storage Model (Row/Record)

MariaDB supports different storage models with different storage engines.

Stored Procedures

Supported

Views

Virtual Views Materialized Views