MySQL: MyISAM or InnoDB?

A lot of people are unsure what’s the difference. Here we will explain shortly what we recommend.

MyISAM

Use this database type when you need a database for fast “SELECT” (read) queries.

  • Fast SELECT queries
  • Lock table instead of rows
  • Slower UPDATE / DELETE queries
  • Need to be optimized (or select FIXED method)

InnoDB

Big database and a much of changes? InnoDB helps!

  • Faster UPDATE / DELETE queries
  • Lock only rows instead of whole tables
  • Slower SELECT queries
  • Recovery possible

So, what should I use?

We recommend MyISAM in most cases. If you’re using big databases and mostly UPDATE or DELETE queries you should use InnoDB. Best option is to mix your databases for correct usage.

Leave a Reply

Your email address will not be published. Required fields are marked *