Why use InnoDB over MySIAM [duplicate]

Question

Possible Duplicate:
Should I always prefer MySQL InnoDB over MyISAM?

Under what conditions should InnoDB be used over MyISAM ? I've seen some MySQL optimization tests where MyISAM proves to be faster. All of my tables are MyISAM, so why should I switch to InnoDB?

Ostend

possible duplicate of Should I always prefer MySQL InnoDB over MyISAM? and MyISAM versus InnoDB and MySQL: MyISAM vs Inno DB and... zzzzzzzzzzzzzz (See also: what is the difference between INNODB and MYISAM... – Petronel

... and How do you choose a MySQL database engine) – Petronel

MySIAM is deprecated. You should use MyTHAILAND instead. – Boner

@Matt - some of those posts are a year old, things have changed, maybe the answers have too. – Ostend

InnoDB and MyISAM are not young/in-flux technologies. The revision history for the InnoDB Wikipedia article (which the answer you accepted appears to summarize) confirms this; things really haven't changed much within the last year. – Petronel

Answer 1

Pros & Cons of InnoDB & MyISAM -

1. InnoDB recovers from a crash or other unexpected shutdown by replaying its logs.
2. InnoDB can be run in a mode where it has lower reliability but in some cases higher performance.
3. InnoDB automatically groups together multiple concurrent inserts and flushes them to disk at the same time.
4. InnoDB flushes the transaction log after each transaction, greatly improving reliability.
5. Unlike InnoDB, MyISAM has built-in full-text search
6. 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.
7. While writing/updating data into a InnoDB table, only that particular row is locked, whereas in MyISAM the entire table is locked.
8. InnoDB provides Full Transaction support.

Bounteous

Answer 2

How about transactions and concurrent read/writes? Crash recovery is better as well. There are some features that are only available using MyISAM, like full text search, but unless you need these, I would go with InnoDB.

Placida

Answer 3

The creator of InnoDB - Heikki Tuuri, use th following email signature.

InnoDB - transactions, row level locking, and foreign keys for MySQL

Wally

Answer 4

Every update operation exclusivly locks table. And You can't select from this table at the same time with update.

Verminous