use myisam instead of innodb create table statement code example Example: change table to innodb mysql ALTER TABLE `tbl` ENGINE=INNODB