InnoDB

MariaDB starting with 10.3.7

In MariaDB 10.3.7 and later, the InnoDB implementation has diverged substantially from the InnoDB in MySQL. Therefore, in these versions, the InnoDB version is no longer associated with a MySQL release version.

MariaDB starting with 10.2

In MariaDB 10.2 and later, the default InnoDB implementation is based on InnoDB from MySQL 5.7. See Why MariaDB uses InnoDB instead of XtraDB from MariaDB 10.2 for more information.

MariaDB until 10.1

In MariaDB 10.1 and before, the default InnoDB implementation is based on Percona's XtraDB. XtraDB is a performance enhanced fork of InnoDB. For compatibility reasons, the system variables still retain their original innodb prefixes. If the documentation says that something applies to InnoDB, then it usually also applies to the XtraDB fork, unless explicitly stated otherwise. In these versions, it is still possible to use InnoDB instead of XtraDB. See Using InnoDB instead of XtraDB for more information.

Title Description
InnoDB Versions From MariaDB 10.2, InnoDB is the default storage engine.
InnoDB Limitations The InnoDB storage engine has the following limitations.
InnoDB Troubleshooting Guidelines when troubleshooting problems with InnoDB .
InnoDB System Variables List and description of XtraDB/InnoDB-related server system variables.
InnoDB Server Status Variables List and description of InnoDB/XtraDB status variables.
AUTO_INCREMENT Handling in InnoDB AUTO_INCREMENT handling in InnoDB and the lock modes.
InnoDB Buffer Pool The most important memory buffer used by InnoDB.
InnoDB Change Buffering Buffering INSERT, UPDATE and DELETE statements for greater efficiency.
InnoDB Doublewrite Buffer Buffer used for recovering from half-written pages.
InnoDB Tablespaces Information on tablespaces in InnoDB, including an overview, system tablesp...
InnoDB File Format Description of the file formats supported by XtraDB/InnoDB.
InnoDB Row Formats InnoDB's row formats are REDUNDANT, COMPACT, DYNAMIC, and COMPRESSED.
InnoDB Strict Mode InnoD strict mode makes InnoDB more reliable.
InnoDB Redo Log The redo log is used by InnoDB during crash recovery.
InnoDB Undo Log InnoDB Undo log.
InnoDB Page Flushing Configuring when and how InnoDB flushes dirty pages to disk.
InnoDB Purge When a transaction updates a row in an InnoDB table, InnoDB's MVCC impleme...
Information Schema InnoDB Tables All InnoDB-specific Information Schema tables.
Information Schema XtraDB Tables All XtraDB-specific Information Schema tables.
InnoDB Online DDL InnoDB tables support online DDL in certain circumstances.
Binary Log Group Commit and InnoDB Flushing Performance Improvement for group commit for InnoDB transactions with the binary log enabled.
InnoDB Page Compression InnoDB page compression, which is more sophisticated than the COMPRESSED row format.
InnoDB Data Scrubbing Ensuring data is completely removed when deleted.
InnoDB Lock Modes InnoDB supports a number of lock modes to ensure that concurrent write operations never collide.
InnoDB Monitors Standard Monitor, Lock Monitor, Tablespace Monitor and the Table Monitor.
InnoDB Encryption Overview Data-at-rest encryption for tables that use the InnoDB and XtraDB storage engines.
About XtraDB XtraDB was an enhanced version of the InnoDB storage engine used until MariaDB 10.2.
Using InnoDB Instead of XtraDB Using the InnoDB plugin instead of XtraDB
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/innodb/