Comparison of storage engines in MySQL and MariaDB

This is a comparison between notable database engines for the MySQL database management system (DBMS). A database engine (or "storage engine") is the underlying software component that a DBMS uses to create, read, update and delete (CRUD) data from a database.

Name Vendor License Transactional Under active development MySQL versions MariaDB versions Archive Oracle GPL 5.0 – present 5.1 – present Aria MariaDB GPL 5.1 – present Berkeley DB Oracle AGPLv3 ? – 5.0 BLACKHOLE Oracle GPL 5.0 – present 5.1 – present CONNECT MariaDB GPL 10.0 – present CSV Oracle GPL 5.0 – present 5.1 – present DuckDB MariaDB GPL experimental, unreleased Falcon Oracle GPL Federated Oracle GPL 5.0 – present 5.1 – FederatedX MariaDB GPL ? – present ColumnStore (formerly InfiniDB) Calpont GPL 10.5.4 – present InnoDB Oracle GPL 3.23 – present 5.1 – present MEMORY Oracle GPL 3.23 – present 5.1 – present Mroonga Groonga Project GPL 10.0 – present MyISAM Oracle GPL 3.23 – present 5.1 – present MyRocks Facebook GPLv2 10.2 – present NDB Oracle GPLv2 OQGRAPH Oracle GPLv2 5.2 – present S3 MariaDB GPL 10.5 – present SEQUENCE MariaDB GPL 10.0 – present Sphinx Sphinx Technologies Inc. GPL 5.2 – present SPIDER Kentoku Shiba GPL 10.0 – present TempTable Oracle GPL 8.0 – present TidesDB (TideSQL) TidesDB GPLv2 experimental 11.8 – present TokuDB Percona Modified GPL 5.5 – 10.6 XtraDB Percona GPL 5.1 – 10.1

References

External links MySQL Documentation on MyISAM Storage Engine MyISAM's open files limit and table-cache problem explained The article about problems which will occur in using MyISAM