mysql存儲引擎 InnoDB >MyISAM

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_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;

mysql存儲引擎 MyISAM > InnoDB

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

 

點閱: 327

By admin

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。

這個網站採用 Akismet 服務減少垃圾留言。進一步了解 Akismet 如何處理網站訪客的留言資料