MyISAM vs. InnoDB, and how to switch engines on existing tables

Summary:

• MyISAM is better for selects
• InnoDB is better for inserts and updates

To switch your table to MyISAM:

ALTER TABLE table_name ENGINER = MyISAM;

To switch your table to InnoDB:

ALTER TABLE table_name ENGINER = InnoDB;