InnoDB和MyISAM之间的区别? [英] Difference between InnoDB and MyISAM?

问题描述

可能重复:
MyISAM与InnoDB

Possible Duplicate:
MyISAM versus InnoDB

好吧，我阅读了Wikipedia的这些信息，InnoDB似乎更好.这是我的问题，可以使用InnoDB代替MyISAM从数据库中选择用户数据吗?还是最好选择与MyISAM在一起.

Ok I read this information of Wikipedia and InnoDB seems better. Here is my question would it be OK to use InnoDB instead of MyISAM for selecting user data from the database? Or would it be better to stay with MyISAM for this.

如果我要更改为Inno，PDO是否仍可以使用它以及某些旧式查询?

And if I would to change to Inno would PDO still work with it and some old style query's?

$q = ("SELECT * ... );
$r = mysql_query($q);

推荐答案

• InnoDB使用行锁定，MyISAM使用 表锁定，因此...
• 涉及到InnoDB较慢 选择
• InnoDB强制执行参照完整性 (这是非常好的事情)
• InnoDB允许交易
• InnoDB uses row locking, MyISAM uses table locking, therefore...
• InnoDB is slower when it comes to SELECT
• InnoDB enforces referential integrity (which is as very good thing)
• InnoDB allows transactions

这篇关于InnoDB和MyISAM之间的区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！