MySQL - Table storage engines types

MyISAM

1. ISAM = Indexed Sequential Access Method
2. good performance
3. no transaction support
4. good for SELECT
5. can be compressed

InnoDB

1. support transaction
2. support foreign keys
3. good for INSERT/UPDATE