Advantages of InnoDB and MyISAM

Advantages of InnoDB over MyISAM:

Row-level locking, transactions, foreign key constraints and crash recovery

Advantages of MyISAM over InnoDB:

Disk space management

All data except for TEXT and BLOB can occupy 8,000 bytes at most

No full text indexing is available for InnoDB

COUNT(*)s execute slower than in MyISAM due to tablespace complexity