Find the best answer to your question, help others answer theirs
If you are going to use a passage of Lorem Ipsum, you need to be sure there
isn't anything embarrassing hidden in the middle of text.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
1 Answer
- 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.(In latest MySQL version InnoDB also support)
-
1Ah excellent! Thank you! - Arden Smith - 8 hours ago
Add a comment
