February 27, 2012
Which MySQL storage engine will be better in my situation
Question by Mukesh Kumar
I have to develop a big application, a School management system; which MySQL storage engine will be better? MyIsam or InnoDB or any other?
Answer by Starx
InnoDb Support Relationships and MyISAM does not. If your application require this features, you should use InnoDB.
Other major differences includes:
- InnoDB is newer while MyISAM is older.
- InnoDB is more complex while MyISAM is simpler.
- InnoDB is more strict in data integrity while MyISAM is loose.
- InnoDB implements row-level lock for inserting and updating while MyISAM implements table-level lock.
- InnoDB has transactions while MyISAM does not.
- InnoDB has foreign keys and relationship contraints while MyISAM does not.
- InnoDB has better crash recovery while MyISAM is poor at recovering data integrity at system crashes.
- MyISAM has full-text search index while InnoDB has not.
By Yang Yang source
See this question and find out yourself, which fits better in the situation.
