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.