Comparison of MySQL database engines

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[1]

|
|
|
|
|
|

Archive | Oracle | GPL | No | Yes | 5.0 – present | 5.1 – present
Aria | MariaDB | GPL | No | Yes | — | 5.1 – present
Berkeley DB | Oracle | AGPLv3 | Yes | No | ? – 5.0 | —
BLACKHOLE | Oracle | GPL | No | Yes | 5.0 – present | 5.1 – present
CONNECT | MariaDB | GPL | No | Yes | — | 10.0 – present
CSV | Oracle | GPL | No | Yes | 5.0 – present | 5.1 – present
Falcon | Oracle | GPL | Yes | No | ? | —
Federated | Oracle | GPL | ? | No | 5.0 – present | ?
FederatedX | MariaDB | GPL | Yes | No | — | ? – present
ColumnStore (formerly InfiniDB) | Calpont | GPL | Yes | Yes | — | 10.5.4 – present
InnoDB | Oracle | GPL | Yes | Yes | 3.23 – present | 5.1 – present[2]
MEMORY | Oracle | GPL | No | Yes | 3.23 – present | 5.1 – present
Mroonga | Groonga Project | GPL | No | Yes | — | 10.0 – present
MyISAM | Oracle | GPL | No | No | 3.23 – present | 5.1 – present
MyRocks | Facebook | GPLv2 | Yes | Yes | — | 10.2 – present
NDB | Oracle | GPLv2 | Yes | Yes | ? | —
OQGRAPH | Oracle | GPLv2 | No | No | — | 5.2 – present
S3 | MariaDB | GPL | No | Yes | — | 10.5 – present
SEQUENCE | MariaDB | GPL | No | Yes | — | 10.0 – present
Sphinx | Sphinx Technologies Inc. | GPL | No | No | — | 5.2 – present
SPIDER | Kentoku Shiba | GPL | Yes | Yes | — | 10.0 – present
TempTable | Oracle | GPL | No | Yes | 8.0 – present | —
TokuDB | Percona | Modified GPL | Yes | No | — | 5.5 – 10.6[3]
XtraDB | Percona | GPL | Yes | Yes | — | 5.1 – 10.1[2]

## References

[edit]

1. ^ "Storage Engines". MariaDB KnowledgeBase. Retrieved 2024-01-25.
2. ^ a b "InnoDB Versions". MariaDB KnowledgeBase. Retrieved 2024-01-25.
3. ^ "TokuDB". MariaDB KnowledgeBase. Retrieved 2024-01-25.

## External links

[edit]

* 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

* v
* t
* e

MySQL and MariaDB

Editions|

* MySQL
* MySQL Enterprise
* MySQL Cluster

SQL GUI tools|

* MySQL Workbench
* SQLyog
* phpMyAdmin
* HeidiSQL
* Navicat
* Database Workbench
* DBeaver

Storage engines|

* MyISAM
* Falcon
* InnoDB
* XtraDB
* MySQL Federated
* MySQL Archive
* Aria
* TokuDB
* MyRocks

Procedural Language|

* MySQL Stored Procedures (a variant of SQL/PSM Standard)

Forks and Branches|

* Drizzle
* MariaDB
* Percona
* WebScaleSQL

*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template