core error

MyISAM vs InnoDB

Posted on: 13/07/2011

MySQL may work with 2 different storage engines. Which one is better? depends on the needs your application has.

Advantages of InnoDB (by default in MySQL)

  • ensures the integrity of the data in our tables (atomicity)
  • if our application does many INSERTs and UPDATEs, the performance will improve

Advantages of MyISAM

  • Much faster in SELECTs

So, if our table is quite dynamic we would need a lot of INSERTs and UPDATES and therefore we will need to work with InnoDB. In case a table is meant to be a source of data mainly, we will need to use MyISAM


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


  • None
  • Justin Cooney: Great comic, this made me laugh!
  • Justin Cooney: Interesting, I didn't know about the Google App Engine, I'm glad I found your article on it!


%d bloggers like this: