ALTER TABLE wp_posts PARTITION BY RANGE(id) ( PARTITION p0 VALUES LESS THAN (70000), PARTITION p1 VALUES LESS THAN (140000), PARTITION p2 VALUES LESS THAN (210000), PARTITION p3 VALUES LESS THAN (280000), PARTITION p4 VALUES LESS THAN (350000), PARTITION p6 VALUES LESS THAN MAXVALUE ); ALTER TABLE wp_postmeta PARTITION BY RANGE(meta_id) ( PARTITION p0 VALUES LESS THAN (140000), PARTITION p1 VALUES LESS THAN (280000), PARTITION p2 VALUES LESS THAN (420000), PARTITION p3 VALUES LESS THAN (560000), PARTITION p4 VALUES LESS THAN (700000), PARTITION p6 VALUES LESS THAN MAXVALUE );
根据id数进行分区。我这边分了6个。
【wordpress wp_posts wp_postmeta 优化】http://www.waitingfy.com/archives/4768
推荐阅读
- 个人博客搭建|wampserver显示红色、橙色的解决方案
- WordPress PHP Fatal Error “Maximum execution time of 30 seconds exceeded” 的解决办法
- lnmp|LNMP动态网站搭建(二)
- python|推荐一个Python的开源小工具大合集！