What is the default storage engine used in MariaDB?

Question

MariaDB has made the InnoDB as the default storage engine since version 5.5. In the earlier version, it used Aria as the default storage engine.

What is default storage engine in MariaDB?

InnoDB is a good general transaction storage engine, and, from MariaDB 10.2, the best choice in most cases. It is the default storage engine from MariaDB 10.2.

What is the default storage engine?

Storage engines (underlying software component) are MySQL components, that can handle the SQL operations for different table types to store and manage information in a database. InnoDB is mostly used general-purpose storage engine and as of MySQL 5.5 and later it is the default engine.

What is the default MySQL storage engine?

There are two types of storage engines in MySQL: transactional and non-transactional. For MySQL 5.5 and later, the default storage engine is InnoDB. The default storage engine for MySQL prior to version 5.5 was MyISAM.

Is MariaDB a database engine?

MariaDB is the most powerful open source relational database – modern SQL and JSON support, Oracle Database compatibility, continuous availability and comprehensive security. MariaDB can be deployed as a standard database, a distributed SQL database or as a data warehouse.

Expert · Answer