François Schiettecatte’s Blog

Good reasons to use myisam tables in MySQL

Posted in Scaling by François Schiettecatte on June 21, 2007

In my previous post I mentioned that my rule of thumb for MySQL table types is to default to innodb unless there is a very good reason to use myisam, so here are some good reasons to use myisam:

  • You are just adding to a table using very few threads (so there is minimal contention) and are never reading from it.
  • You are just reading from a table and very seldom updating it.

Thats about it…

Leave a Reply

You must be logged in to post a comment.