Difference between revisions of "Show engines;"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | MariaDB [(none)]> show engines; | |
| + | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | ||
| + | | Engine | Support | Comment | Transactions | XA | Savepoints | | ||
| + | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | ||
| + | | MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | ||
| + | | CSV | YES | Stores tables as CSV files | NO | NO | NO | | ||
| + | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | ||
| + | | MyISAM | YES | Non-transactional engine with good performance and small data footprint | NO | NO | NO | | ||
| + | | SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES | | ||
| + | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO | | ||
| + | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | ||
| + | | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES | | ||
| + | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | ||
| + | 8 rows in set (0.00 sec) | ||
| + | |||
== Related commands == | == Related commands == | ||
Revision as of 12:29, 5 May 2021
https://mariadb.com/kb/en/show-engines/
MariaDB [(none)]> show engines; +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | Stores tables as CSV files | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | YES | Non-transactional engine with good performance and small data footprint | NO | NO | NO | | SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ 8 rows in set (0.00 sec)
Related commands
See also
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.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
Advertising:
