Convert InnoDB Tables to MyISAM

Convert default WordPress tables from InnoDB to MyISAM, use MySQL query:

ALTER TABLE wp_commentmeta ENGINE = MyISAM;
ALTER TABLE wp_comments ENGINE = MyISAM;
ALTER TABLE wp_links ENGINE = MyISAM;
ALTER TABLE wp_options ENGINE = MyISAM;
ALTER TABLE wp_postmeta ENGINE = MyISAM;
ALTER TABLE wp_posts ENGINE = MyISAM;
ALTER TABLE wp_termmeta ENGINE = MyISAM;
ALTER TABLE wp_terms ENGINE = MyISAM;
ALTER TABLE wp_term_relationships ENGINE = MyISAM;
ALTER TABLE wp_term_taxonomy ENGINE = MyISAM;
ALTER TABLE wp_usermeta ENGINE = MyISAM;
ALTER TABLE wp_users ENGINE = MyISAM;

Leave a comment

BlogLogistics