它可以被定义为数据库管理系统（dbms）用来处理不同的sql操作（如创建、读取、更新和删除数据库中的数据）的软件组件。换句话说，它被dbms用来管理数据库中的信息。最常用的存储引擎是innodb，它也是mysql5.5及更高版本的默认存储引擎。在mysql5.5之前，默认的存储引擎是myisam。
通过使用show engines命令，我们可以检查mysql安装支持的存储引擎列表−
mysql> show engines\g
*************************** 1. row *************************** engine: federated support: no comment: federated mysql storage enginetransactions: null xa: null savepoints: null*************************** 2. row *************************** engine: mrg_myisam support: yes comment: collection of identical myisam tablestransactions: no xa: no savepoints: no*************************** 3. row *************************** engine: myisam support: yes comment: myisam storage enginetransactions: no xa: no savepoints: no*************************** 4. row *************************** engine: blackhole support: yes comment: /dev/null storage engine (anything you write to it disappeartransactions: no xa: no savepoints: no*************************** 5. row *************************** engine: csv support: yes comment: csv storage enginetransactions: no xa: no savepoints: no*************************** 6. row *************************** engine: memory support: yes comment: hash based, stored in memory, useful for temporary tablestransactions: no xa: no savepoints: no*************************** 7. row *************************** engine: archive support: yes comment: archive storage enginetransactions: no xa: no savepoints: no*************************** 8. row *************************** engine: innodb support: default comment: supports transactions, row-level locking, and foreign keystransactions: yes xa: yes savepoints: yes*************************** 9. row *************************** engine: performance_schema support: yes comment: performance schematransactions: no xa: no savepoints: no9 rows in set (0.00 sec)
以上就是什么是存储引擎以及如何查看mysql安装支持的存储引擎列表？的详细内容。