Comparison of MySQL database engines: Difference between revisions

Revision as of 07:40, 25 January 2024

Latest revision as of 04:30, 29 July 2025

(6 intermediate revisions by 5 users not shown)

Line 1:

{{short description|Nonenone}}

{{unreferenced|date=March 2010}}

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]].

{{table alignment}}

{| class="wikitable sortable col6center col7center"

|-

! Name !! Vendor !! License !! [[Database transaction#Transactional databases|Transactional]] !! Under active development !! MySQL versions !! MariaDB versions<ref>{{Cite web |title=Storage Engines |url=https://mariadb.com/kb/en/storage-engines/ |access-date=2024-01-25 |website=MariaDB KnowledgeBase}}</ref>

|-

| [[MySQL Archive|Archive]] || Oracle || GPL || {{No}} || {{Yes}} || 5.0 -– present || 5.1 -– present

|-

| [[Aria (storage engine)|Aria]] || [[MariaDB]] || GPL || {{No}} || {{Yes}} || None{{N/A}} || 5.1 -– present

|-

| [[Berkeley DB]] || Oracle || [[GNU Affero General Public License|AGPLv3]] || {{Yes}} || {{No}} || {{dunno}}? -– 5.0 || None{{N/A}}

|-

| [[BLACKHOLE]] || Oracle || GPL || {{No}} || {{Yes}} || 5.0 -– present || 5.1 -– present

|-

| [[CONNECT (storage engine)|CONNECT]] || [[MariaDB]] || GPL || {{No}} || {{Yes}} || None{{N/A}} || 10.0 -– present

|-

| [[CSV (storage engine)|CSV]] || Oracle || GPL || {{No}} || {{Yes}} || 5.0 -– present || 5.1 -– present

|-

| [[Falcon (storage engine)|Falcon]] || Oracle || GPL || {{Yes}} || {{No}} || {{dunno}} || None{{N/A}}

|-

| [[MySQL Federated|Federated]] || Oracle || GPL || {{dunno}} || {{No}} || 5.0 -– present || 5.1 -– {{dunno}}

|-

| [[FederatedX]] || [[MariaDB]] || GPL || {{Yes}} || {{No}} || None || {{dunnoN/A}} -|| ? – present

|-

| [[InfiniDB|ColumnStore (formerly InfiniDB)]] || Calpont|| GPL || {{Yes}} || {{Yes}} || None{{N/A}} || 10.5.4 -– present

|-

| [[InnoDB]] || Oracle || GPL || {{Yes}} || {{Yes}} || 3.23 -– present || 5.1 -– present <ref name="mdb_innodb" />

|-

| [[MEMORY (storage engine)|MEMORY]] || Oracle || GPL || {{No}} || {{Yes}} || 3.23 -– present || 5.1 -– present

|-

| Mroonga || Groonga Project || GPL || {{No}} || {{Yes}} || None{{N/A}} || 10.0 -– present

|-

| [[MyISAM]] || Oracle || GPL || {{No}} || {{No}} || 3.23 -– present || 5.1 -– present

|-

| [[MyRocks]] || Facebook || GPLv2 || {{Yes}} || {{Yes}} || None{{N/A}} || 10.2 -– present

|-

| [[MySQL Cluster|NDB]] || Oracle || GPLv2 || {{Yes}} || {{Yes}} || {{dunno}} || None{{N/A}}

|-

| [[OQGRAPH]] || Oracle || GPLv2 || {{No}} || {{No}} || None{{N/A}} || 5.2 -– present

|-

| [[S3 (storage engine)|S3]] || [[MariaDB]] || GPL || {{No}} || {{Yes}} || None{{N/A}} || 10.5 -– present

|-

| SEQUENCE || MariaDB || GPL || {{No}} || {{Yes}} || None{{N/A}} || 10.0 -– present

|-

| [[Sphinx (search engine)#SphinxSE|Sphinx]] || Sphinx Technologies Inc. || GPL || {{No}} || {{No}} || None{{N/A}} || 5.2 -– present

|-

| [[SPIDER (storage engine)|SPIDER]] || Kentoku Shiba || GPL || {{Yes}} || {{Yes}} || None{{N/A}} || 10.0 -– present

|-

| [[TempTable]] || Oracle || GPL || {{No}} || {{Yes}} || 8.0 -– present || None{{N/A}}

|-

| [[TokuDB]] || Percona || Modified GPL || {{Yes}} || {{No}} || None{{N/A}} || 5.5 -– 10.6<ref>{{Cite web |title=TokuDB |url=https://mariadb.com/kb/en/tokudb/ |access-date=2024-01-25 |website=MariaDB KnowledgeBase}}</ref>

|-

| [[XtraDB]] || Percona || GPL || {{Yes}} || {{Yes}} || None{{N/A}} || 5.1 -– 10.1<ref name="mdb_innodb">{{Cite web |title=InnoDB Versions |url=https://mariadb.com/kb/en/innodb-versions/ |access-date=2024-01-25 |website=MariaDB KnowledgeBase}}</ref>

|}