MyISAM vs InnoDB

what are the difference between InnoDB and MyISAM?

Source: http://opentechlovers.wordpress.com/2014/11/12/myisam-vs-innodb/

MyISAM
(+)

Designed with a thinking that database are frequently read not updated.
Simple to understand and implement.
Has full text searching capability.
Good for frequent read operations(when several computations are executing simultaneously)
Faster reads and writes for small to medium sized tables.
Lock tables while updating.
Count(*) queries are fast

(-)

Non-transactional. Data loss issues during crashes.
Table level locking
Insert and update queries are scaleable, concurrency issues

InnoDB
(+)

Designed with a thinking that database are frequently updated not read.
Transaction-safe
Data-integrity is maintained throughout the entire query process.
Clustering by primary key for faster lookups and ordering.
Transactional, crash-safe, better online backup capability.
Allow multiple updates on single table
Locks only row, not table.

(-)

Slower writes(insert, update queries)
Slower BLOB handling
Count(*) queries require full table scan.

 



and pray will not be extinguished by all the storm that howls about it.

Nick Cave - 20,000th day on the planet Earth