Lazy Programmer

Your source for the latest in deep learning, big data, data science, and artificial intelligence. Sign up now

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

April 15, 2013

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;