Performance
Cost per row measured in a single session with 262,144 rows, against the engines built into MariaDB:
- Inserts 7 to 15 times faster than InnoDB, at the level of the MEMORY engine.
- Updates 9 to 11 times faster than InnoDB.
- Primary key lookups about 5 times faster than InnoDB.
- Full scans about 2 times faster than InnoDB.
- Deleting all rows of a table more than 250 times faster than InnoDB.
- Tables shared across sessions: 2 to 3 times faster than InnoDB for inserts, updates and lookups.
Transactional features
- Transactions with row-level locking.
- Foreign keys with cascades, following InnoDB's rules.
- System-versioned tables and full-text indexes.
- In-place ALTER TABLE.
- Tables private to one session or shared across sessions.
MariaDB core defect fixes (AI-powered)
Building the engine exposed defects in the MariaDB server core, which we analyzed and fixed with AI-powered engineering.