Comments

04 Mei 2016

My Journey to WP_POSTS InnoDB Part 1

Posted by at 02.03 Read our previous post

https://mattgadient.com/2012/12/30/how-to-remove-a-fulltext-index-in-mysql-switching-from-myisam-to-innodb/

wp_post:

SHOW CREATE TABLE wp_posts
ALTER TABLE wp_posts DROP INDEX crp_related;
ALTER TABLE wp_posts ENGINE=InnoDB;

wp_postmeta:

SHOW CREATE TABLE wp_postmeta
ALTER TABLE wp_postmeta ENGINE=InnoDB;


wp_options:

SHOW CREATE TABLE wp_options
ALTER TABLE wp_options ENGINE=InnoDB;

OTHER:

ALTER TABLE wp_usermeta ENGINE=InnoDB;
ALTER TABLE wp_users ENGINE=InnoDB;




Supported by Android App Download! ©2012 Ramnul All Content Copyrighted and may not reproduced on other website