Why use InnoDB over MySIAM [duplicate]
Pros & Cons of InnoDB & MyISAM -
- InnoDB recovers from a crash or other unexpected shutdown by replaying its logs.
- InnoDB can be run in a mode where it has lower reliability but in some cases higher performance.
- InnoDB automatically groups together multiple concurrent inserts and flushes them to disk at the same time.
- InnoDB flushes the transaction log after each transaction, greatly improving reliability.
- Unlike InnoDB, MyISAM has built-in full-text search
- MyISAM is still widely used in web applications as it has traditionally been perceived as faster than InnoDB in situations where most DB access is reads.
- While writing/updating data into a InnoDB table, only that particular row is locked, whereas in MyISAM the entire table is locked.
- InnoDB provides Full Transaction support.