CODEWITHSUNDEEP
mysqlinnodbmyisam
n00b
n00b

Reputation: 16566

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

InnoDB seems almost entirely superior but in what case should I go for MyIsam?

Thanks in advance!

Upvotes: 0

Views: 273

Answers (1)

xil3
xil3

Reputation: 16449

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.

Upvotes: 1

Related Questions