wordpress wp_posts wp_postmeta 优化

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

http://www.waitingfy.com/archives/4768

wordpress | RSS 2.0 | Respond | Trackback |