linux - MySQL存储引擎选择InnoDB与MyISAM

Question

我要做一个 问答的网站 请问存储引擎改选用那个

后期可以更改存储引擎吗？

求帮助 谢谢

Answer 1

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.

Answer 2

Without any hesitation, use the mysql5.6 InnoDB engine directly.

Answer 3

If you don’t know which one to choose, choose innodb. Can be switched later.

Answer 4

Mylsam read performance is higher, but there are no transactions