MyISAM (static vs Dynamic):
- All fields have fixed width vs blobs or text with datatypes of different length
- In case of corruption, you lose less data on static setups
- Each table is a separate file as oppose to InnoDB
InnoDB:
- Allows transactions, foreign key constrains, crash recovery
- Stores in tablespace (instead of files as in MyISAM), count(*) takes longer