Comparison of MySQL database engines: Difference between revisions

Revision as of 13:34, 27 January 2025

Latest revision as of 04:30, 29 July 2025

(One intermediate revision by the same user not shown)

Line 2:

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>

Line 11:

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

|-

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

|-

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

Line 23:

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

|-

| [[FederatedX]] || [[MariaDB]] || GPL || {{Yes}} || {{No}} || {{N/A}} || {{dunno}}? – present

|-

| [[InfiniDB|ColumnStore (formerly InfiniDB)]] || Calpont|| GPL || {{Yes}} || {{Yes}} || {{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