Depends on your needs. As shown above, the performance of myisam reading will be better, but there is no transaction. Myisam manages indexes, so index queries will be fast, while innodb manages both indexes and content.
In summary, if the project is not too large, myisam is recommended. If it exceeds one million or transaction security is required, then innodb is recommended.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Depends on your needs. As shown above, the performance of myisam reading will be better, but there is no transaction.
Myisam manages indexes, so index queries will be fast, while innodb manages both indexes and content.
In summary, if the project is not too large, myisam is recommended. If it exceeds one million or transaction security is required, then innodb is recommended.
Without any hesitation, use the mysql5.6 InnoDB engine directly.
If you don’t know which one to choose, choose innodb. Can be switched later.
Mylsam read performance is higher, but there are no transactions