MyISAM和InnoDB区别

<ul> <li><a href="https://www.bilibili.com/video/BV1pA411H7Vd?p=2">https://www.bilibili.com/video/BV1pA411H7Vd?p=2</a></li> </ul> <h3>MyISAM与InnoDB区别</h3> <ul> <li>存储引擎支持特性</li> <li>索引</li> <li>事务</li> <li>锁</li> <li>外键</li> </ul> <h2>MyISAM与InnoDB区别对比</h2> <table> <thead> <tr> <th>区别选项</th> <th>MyISAM</th> <th>InnoDB</th> </tr> </thead> <tbody> <tr> <td>索引类型</td> <td>非聚簇索引</td> <td>聚簇索引</td> </tr> <tr> <td>支持事务</td> <td>否</td> <td>是</td> </tr> <tr> <td>支持表锁</td> <td>是</td> <td>是</td> </tr> <tr> <td>支持行锁</td> <td>否</td> <td>是</td> </tr> <tr> <td>支持外键</td> <td>否</td> <td>是</td> </tr> <tr> <td>支持全文索引</td> <td>是</td> <td>是(5.6以后支持)</td> </tr> <tr> <td>适合操作类型</td> <td>大量查询</td> <td>大量增删改</td> </tr> </tbody> </table>