开发者

MySQL: In which case should I choose MyIsam over innoDB?

开发者 https://www.devze.com 2023-01-05 16:27 出处:网络
InnoDB seems almost entirely superior but in w开发者_StackOverflow中文版hat case should I go for MyIsam?

InnoDB seems almost entirely superior but in w开发者_StackOverflow中文版hat case should I go for MyIsam?

Thanks in advance!


MyIsam is much faster if you don't plan on having lots of traffic/transactions.

The problem with MyIsam is that it locks the table when it's in use, whereas innodb just locks the row. Innodb is a bit slower because of this, but allows simultaneous access to the same table, so it's more suitable for heavy traffic/transactions.

So, to conclude - if you don't expect your site to be accessing your database that much and it's low traffic, then myIsam is usually the best option for speed.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号