内容字号:默认大号超大号

段落设置:段首缩进取消段首缩进

字体设置:切换到微软雅黑切换到宋体

wordpress wp_posts wp_postmeta优化

2018-08-04 17:39 出处:清屏网 人气: 评论(0

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个。

4768


分享给小伙伴们:
本文标签: wordpress

相关文章

发表评论愿您的每句评论,都能给大家的生活添色彩,带来共鸣,带来思索,带来快乐。

CopyRight © 2015-2016 QingPingShan.com , All Rights Reserved.

清屏网 版权所有 豫ICP备15026204号