1.查看Mysql全部存储引擎;
`show engines;`
InnoDB
MRG_MYISAM
MEMORY
BLACKHOLE
MyISAM
CSV
ARCHIVE
PERFORMANCE_SCHEMA
FEDERATED
2.分析对比![](https://box.kancloud.cn/2f2736eb2a8e66cfd026390d8b3de920_2178x1760.png)
3. 查看表的存储引擎;
`mysql> show create table worldec_runoob;` #worldec_runoob表名字;
`mysql> show table status where name='worldec_runoob' \G;`
4.ACID是什么意思;
atomic、commit、isolation leve、doublewrite buffer、concurrency、rollback、transaction、locking