Difference between revisions of "MariaDB engines"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
| − | * Show [[MariaDB engines|database engine]]: <pre>show table status like '<table name>';</pre> | + | * Show [[MariaDB engines|database engine]]: |
| + | [[show table status]] | ||
| + | <pre>show table status like '<table name>';</pre> | ||
Revision as of 12:33, 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
show table status like '<table name>';
Activities
Related terms
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:
