我可以在ONE数据库中使用InnoDB和MyISAM表吗？ [英] Can I use InnoDB and MyISAM tables in ONE database?

问题描述

显然，两者都有好处。 MyISAM很快，但可能容易受到打扰，InnoDB缓慢但由于事务和外键而更加稳定。所以将两个引擎混合在一个数据库中可能会很好。如果可以的话可以吗？

解决方案

记住！可以在同一个数据库中混合表格类型！实际上它是推荐和经常需要的。但是，请注意，如果在加入这两种类型时遇到性能问题，请尝试将一个转换为另一个，并确定是否修复它。这个问题不会经常发生，但已被报告。

取自 MySQL - InnoDB和MyISAM

Obviously both have their benefits. MyISAM is fast but may get currupted easily, InnoDB is slow but is more stable thanks to transactions and foreign keys. So it could be good to mix both engines in one database. If that's possible?

解决方案

REMEMBER! It's OK to mix table types in the same database! In fact it's recommended and frequently required. However, it is important to note that if you are having performance issues when joining the two types, try converting one to the other and see if that fixes it. This issue does not happen often but it has been reported.

Taken from MySQL - InnoDB vs MyISAM

这篇关于我可以在ONE数据库中使用InnoDB和MyISAM表吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！