Difference between revisions of "Show engines;"
Jump to navigation
Jump to search
(10 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{lc}} | ||
https://mariadb.com/kb/en/show-engines/ | https://mariadb.com/kb/en/show-engines/ | ||
− | + | MariaDB [(none)]> show engines; | |
− | MariaDB [(none)]> show engines; | + | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ |
− | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | + | | Engine | Support | Comment | [[Transactions]] | XA | [[Savepoints]] | |
− | | Engine | Support | Comment | Transactions | XA | Savepoints | | + | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ |
− | +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ | + | | MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | |
− | | MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | + | | CSV | YES | Stores tables as CSV files | 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 | |
− | | 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 | |
− | | 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 | |
− | | SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES | | + | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO | |
− | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO | | + | | PERFORMANCE_SCHEMA | YES | Performance Schema | 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 | |
− | | 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) |
− | 8 rows in set (0.00 sec) | ||
− | |||
+ | == Related commands == | ||
+ | * <code>[[show plugins]]</code> | ||
+ | * <code>[[show tables]]</code> | ||
== See also == | == See also == | ||
+ | * {{MariaDB engines}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
+ | |||
+ | [[Category:MariaDB]] |
Latest revision as of 19:54, 15 December 2022
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[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
, 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: