Good reasons to use myisam tables in MySQL

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…

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: