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.
-
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 InnoDB-related server system variables. -
InnoDB Server Status Variables
List and description of InnoDB 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 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
Purge process to remove old versions of a row from the undo log. -
Information Schema InnoDB Tables
All InnoDB-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 storage engine. -
InnoDB - Unmaintained
Articles that apply only to old, unmaintained versions of MariaDB.