mysql分区

方式一：Range分区

#注意：创建表和分区语句间不能有分号
CREATE TABLE USER (
    id INT primary key,
    name VARCHAR(30)
)
partition BY RANGE (id) (
    partition p0 VALUES LESS THAN (5),
    partition p1 VALUES LESS THAN (10),
    partition p2 VALUES LESS THAN (15),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

方式二：List

#注意list分区需手动指定散列值
CREATE TABLE USER (
    id INT primary key,name VARCHAR(30)
)
partition BY List (id) (
    PARTITION p0 VALUES IN (1,4,7),
    PARTITION p1 VALUES IN (2,3,8),
    PARTITION p0 VALUES IN (3,6,9)
);

方式三：Hash

CREATE TABLE USER (
    id INT primary key,name VARCHAR(30)
)
partition BY hash (id) PARTITIONS 4;

方式四：Key

CREATE TABLE USER (
    id INT primary key,name VARCHAR(30)
)
partition BY linear key (id) PARTITIONS 4;