本文介绍了MySQL数据库支持的九种存储引擎，包括InnoDB、MyISAM、MEMORY等，并强调了InnoDB和MyISAM作为最常用的两种。InnoDB支持事务处理、行级锁定和外键，适合需要高并发和数据一致性的场景；而MyISAM则是默认引擎，不支持事务，适合读取密集型应用。
查询当前MySQL数据库支持的哪些存储引擎的方法：
mysql> SHOW ENGINES;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| MyISAM | DEFAULT | MyISAM storage engine | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
MySQL5.5以后的版本都支持以上的九种存储引擎
InnoDB,MyISAM,Memory,MRG_MYISAM,Archive,Federate,CSV,BLACKHOLE，PERFORMANCE_SCHEMA
其中最常用到的就InnoDB与MyISA
981
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
