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;






Deep Learning and Artificial Intelligence Newsletter

Get discount coupons, free machine learning material, and new course announcements