ENGINE Table Option for MariaDB Xpand

Overview

MariaDB Xpand supports the ENGINE table option for compatibility with MariaDB Server and MySQL.

TYPE is an alias for ENGINE.

Supported ENGINE types

  • Xpand most closely matches the InnoDB storage engine. All tables in Xpand are fully transactional and ACID-compliant and use the MVCC model for concurrency control. For compatibility purposes, the default engine type is listed as InnoDB but the Clustrix engine type is applied.

  • Xpand also accepts syntax for setting the engine type to ndb, ndbcluster, myisam, mrg_mysisam but the Clustrix engine is always used.

  • Xpand also supports ENGINE=MEMORY