InnoDB Versions

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.

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.

Note

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.

Divergences

Some examples of divergences between MariaDB's InnoDB and MySQL's InnoDB are:

• (which is based on MySQL 5.6) included encryption and variable-size page compression before MySQL 5.7 introduced them.

• (based on MySQL 5.7) introduced persistent AUTO_INCREMENT () in a GA release before MySQL 8.0.

• (based on MySQL 5.7) introduced instant ADD COLUMN () before MySQL.

_{This page is licensed: CC BY-SA / Gnu FDL}