Mysql MyISAM vs InnoDB

Advantages of MyISAM:

• Handle SELECT and INSERT very quickly
• Need less disk space
• Support FULLTEXT indexes

Advantages of InnoDB:

• Handle UPDATE quickly
• Can handle transactions (low-level locking)
• Support foreign key constraints