Comparison of MySQL database engines

Short description: none

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 | N/A | 5.1 – present
Berkeley DB | Oracle | AGPLv3 | Yes | No | ? – 5.0 | N/A
BLACKHOLE | Oracle | GPL | No | Yes | 5.0 – present | 5.1 – present
CONNECT | MariaDB | GPL | No | Yes | N/A | 10.0 – present
CSV | Oracle | GPL | No | Yes | 5.0 – present | 5.1 – present
Falcon | Oracle | GPL | Yes | No | ? | N/A
Federated | Oracle | GPL | ? | No | 5.0 – present | ?
FederatedX | MariaDB | GPL | Yes | No | N/A | ? – present
ColumnStore (formerly InfiniDB) | Calpont | GPL | Yes | Yes | N/A | 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 | N/A | 10.0 – present
MyISAM | Oracle | GPL | No | No | 3.23 – present | 5.1 – present
MyRocks | Facebook | GPLv2 | Yes | Yes | N/A | 10.2 – present
NDB | Oracle | GPLv2 | Yes | Yes | ? | N/A
OQGRAPH | Oracle | GPLv2 | No | No | N/A | 5.2 – present
S3 | MariaDB | GPL | No | Yes | N/A | 10.5 – present
SEQUENCE | MariaDB | GPL | No | Yes | N/A | 10.0 – present
Sphinx | Sphinx Technologies Inc. | GPL | No | No | N/A | 5.2 – present
SPIDER | Kentoku Shiba | GPL | Yes | Yes | N/A | 10.0 – present
TempTable | Oracle | GPL | No | Yes | 8.0 – present | N/A
TokuDB | Percona | Modified GPL | Yes | No | N/A | 5.5 – 10.6[3]
XtraDB | Percona | GPL | Yes | Yes | N/A | 5.1 – 10.1[2]

## References

1. ↑ "Storage Engines". https://mariadb.com/kb/en/storage-engines/.
2. ↑ 2.0 2.1 "InnoDB Versions". https://mariadb.com/kb/en/innodb-versions/.
3. ↑ "TokuDB". https://mariadb.com/kb/en/tokudb/.

## 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

* v
* t
* e

MySQL

Editions|

* MySQL
* MySQL Enterprise
* MySQL Cluster

MySQL tools|

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

Storage engines|

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

Procedural Language|

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

Forks and Branches|

* Drizzle
* MariaDB
* Percona
* WebScaleSQL

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Comparison of MySQL database engines. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Comparison_of_MySQL_database_engines&oldid=3967927"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template