MyISAM vs InnoDB decision matrix

By | December 19, 2010

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

Leave a Reply

Your email address will not be published. Required fields are marked *