mysql - MylSAM与 InnoDB的主要区别？在业务中大家如何选择的

Question

MylSAM与 InnoDB的主要区别？在业务中大家如何选择的

Answer 1

If you search online, you can refer to http://www.cnblogs.com/villion/archive/2009/07/09/1893762.html

Answer 2

Chado MylSAM
Write long InnoDB
Transaction strict InnoDB

In actual projects, we have all moved to InnoDB

Answer 3

If your mysql version is later than 5.6, then the default storage engine is InnoDB. After 5.6, the performance of InnoDB has been optimized very well, and MylSAM can basically be abandoned.
If it is a version before 5.6, you can consider @vus520's answer, because MylSAM does not support foreign key and transaction operations, and is only suitable for simple table relationships. InnoDB basically supports all situations.