一、MySQL有哪些引擎
在MySQL的官方文档中,将引擎分为innodb 引擎和其他可选引擎,如果要查阅InnoDB之外的引擎文档,点击Alternative Storage Engines即可展开菜单
在MySQL中,通过SHOW ENGINES;
语句可以查看当前所支持的引擎。以MySQL5.7为例,查询出来的数据如下::
Engine | Support | Comment | Transactions | XA | Savepoints |
---|---|---|---|---|---|
InnoDB | DEFAULT | 支持事务、行级锁、外键 | YES | YES | YES |
MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
MyISAM | YES | MyISAM storage engine | NO | NO | NO |
CSV | YES | CSV storage engine | NO | NO | NO |
ARCHIVE</ |