Difference between revisions of "MariaDB engines"
Jump to navigation
Jump to search
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | * [[MyISAM]] ([[. | + | |
| + | |||
| + | * [[MyISAM]] (<code>[[.MYI]]</code>) | ||
* [[InnoDB]], is the default storage engine from [[MariaDB 10.2]] | * [[InnoDB]], is the default storage engine from [[MariaDB 10.2]] | ||
* [[Aria]], a crash-safe alternative to MyISAM | * [[Aria]], a crash-safe alternative to MyISAM | ||
* [[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. | ||
| − | * Show [[MariaDB engines|database engine]]: < | + | * Show [[MariaDB engines|database engine]]: |
| + | * <code>[[show table status]]</code> | ||
| + | * <code>show table status like '<table name>';</code> | ||
| Line 14: | Line 20: | ||
* Read https://mariadb.com/kb/en/choosing-the-right-storage-engine/ | * Read https://mariadb.com/kb/en/choosing-the-right-storage-engine/ | ||
| − | ==See also == | + | == Related terms == |
| + | * <code>[[show tables]]</code> | ||
| + | |||
| + | == See also == | ||
| + | * {{MariaDB engines}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
| − | |||
[[Category:MariaDB]] | [[Category:MariaDB]] | ||
Latest revision as of 19:52, 15 December 2022
- 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 statusshow table status like '';
Activities[edit]
Related terms[edit]
See also[edit]
- MariaDB engines: MyISAM, Aria, InnoDB, XtraDB,
show engines; - 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/
- MariaDB engines: MyISAM, Aria, InnoDB, XtraDB,
Advertising:
