什么是存储引擎以及如何查看 MySQL 安装支持的存储引擎列表？
它可以定义为数据库管理系统(DBMS)用来处理不同SQL操作（如从数据库中创建、读取、更新和删除数据）的软件组件。换句话说，DBMS使用它来管理数据库中的信息。使用最广泛的存储引擎是InnoDB，它也是MySQL5.5及以上版本的默认存储引擎。在MySQL5.5之前，默认的存储引擎是MyISAM。
在SHOWENGINES命令的帮助下，我们可以检查MySQL安装支持的存储引擎列表-
mysql> SHOW ENGINES\G
*************************** 1. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
Transactions: NULL
XA: NULL
Savepoints: NULL
*************************** 2. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 3. row ***************************
Engine: MyISAM
Support: YES
Comment: MyISAM storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: BLACKHOLE
Support: YES
Comment: /dev/null storage engine (anything you write to it disappear
Transactions: NO
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 6. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 8. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 9. row ***************************
Engine: PERFORMANCE_SCHEMA
Support: YES
Comment: Performance Schema
Transactions: NO
XA: NO
Savepoints: NO
9 rows in set (0.00 sec)热门推荐
6 年月日祝福语简短
10 祝寿时祝福语简短精辟
11 对离岗同事祝福语简短
12 圆圆的祝福语简短
13 修祖屋祝福语简短
14 早安祝福语大全简短励志
15 Q穷人结婚祝福语简短
16 职场祝福语大全 简短精辟
17 关于开车的祝福语简短
18 青春告白祖国简短祝福语