mysql innodb 与 MyISAM
Possible Duplicate:
MyISAM versus InnoDB
Hi there,
In MySQL, which storage engine is faster? InnoDB or MyISAM?
Can any one list their +/- here?
not detailed list but in short.
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不确定你能得到明确的答案。我认为 MyISAM 对于许多简单查询来说速度更快，但是它只有表级锁。另一方面，InnoDB 使用行锁定，这可能意味着当您同时运行多个大型查询时速度会更快。
I'm not sure you can get a definitive answer. I think MyISAM is faster for many simple queries, however, it only has table-level locks. InnoDB, on the other-hand uses row-locking, which could mean things are faster when you are running multiple large queries concurrently.