Ever had problem choosing the right MySQL storage engine? Here is a simple matrix for you to make your decision
| Is your table is going to be inserted, deleted, and updated much much more than it is going to be selected? | InnoDB |
| If you need full-text search | MyISAM |
| If you prefer/require relational database design | InnoDB |
| Is disk-space or ram an issue? | MyISAM |
| In Doubt? | MyISAM |
reference: http://www.mikebernat.com/blog/MySQL_-_InnoDB_vs_MyISAM
| Is your table is going to be inserted, deleted, and updated much much more than it is going to be selected? | InnoDB |
| If you need full-text search | MyISAM |
| If you prefer/require relational database design | InnoDB |
| Is disk-space or ram an issue? | MyISAM |
| In Doubt? | MyISAM |