Difference between revisions of "MariaDB engines"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
Tags: Mobile web edit, Mobile edit |
||
| Line 6: | Line 6: | ||
<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. | ||
| + | |||
| + | |||
| + | * Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre> | ||
Revision as of 11:44, 25 August 2020
- MyISAM
- 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/
Advertising:
