Difference between revisions of "MariaDB engines"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
* [[XtraDB]] | * [[XtraDB]] | ||
+ | |||
+ | * <code>[[show engines]]</code> | ||
<code>[[mariabackup]]</code> support for online backups of [[InnoDB]], [[Aria]] and [[MyISAM]] tables. | <code>[[mariabackup]]</code> support for online backups of [[InnoDB]], [[Aria]] and [[MyISAM]] tables. |
Revision as of 12:31, 5 May 2021
- MyISAM (.myi)
- InnoDB, is the default storage engine from MariaDB 10.2
- Aria, a crash-safe alternative to MyISAM
- XtraDB
mariabackup
support for online backups of InnoDB, Aria and MyISAM tables.
- Show database engine:
show table status like '<table name>';
Activities
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
Advertising: