MySQL: MyISAM or InnoDB?

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


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)


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.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.

Diese Website verwendet Akismet, um Spam zu reduzieren. Erfahre mehr darüber, wie deine Kommentardaten verarbeitet werden.