MariaDB engines

• MyISAM (.myi)
• InnoDB, is the default storage engine from MariaDB 10.2
• Aria, a crash-safe alternative to MyISAM
• XtraDB

• show engines

mariabackup support for online backups of InnoDB, Aria and MyISAM tables.

• Show database engine:

show table status

show table status like '<table name>';

Activities

• Read https://mariadb.com/kb/en/choosing-the-right-storage-engine/

Related terms

• show tables

See also

• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306, /etc/mysql/
• MySQL, mysqldump, mysqladmin, XtraBackup, MySQL Enterprise Backup, MyISAM, /var/log/mysql/, MySQL Workbench, Adminer, ib_logfile0, mysqld --help --verbose, MySQL versions