mysql分区部类

mysql分区类型 分区类型 ? 1、RANGE分区 ? CREATE TABLE employees ( ? ? id INT NOT NULL, ? ? fname VARCHAR(30), ? ? lname VARCHAR(30), ? ? hired DATE NOT NULL DEFAULT '1970-01-01', ? ? separated DATE NOT NULL DEFAULT '9999-12-31', ? ? job_code

分区类型

?

1、RANGE分区

?

CREATE TABLE employees (

? ? id INT NOT NULL,

? ? fname VARCHAR(30),

? ? lname VARCHAR(30),

? ? hired DATE NOT NULL DEFAULT '1970-01-01',

? ? separated DATE NOT NULL DEFAULT '9999-12-31',

? ? job_code INT NOT NULL,

? ? store_id INT NOT NULL

)

PARTITION BY RANGE (store_id) (

? ? PARTITION p0 VALUES LESS THAN (6),

? ? PARTITION p1 VALUES LESS THAN (11),

? ? PARTITION p2 VALUES LESS THAN (16),

? ? PARTITION p3 VALUES LESS THAN (21)

)；

?

2、LIST分区

?

CREATE TABLE employees (

? ? id INT NOT NULL,

? ? fname VARCHAR(30),

? ? lname VARCHAR(30),

? ? hired DATE NOT NULL DEFAULT '1970-01-01',

? ? separated DATE NOT NULL DEFAULT '9999-12-31',

? ? job_code INT,

? ? store_id INT

)

PARTITION BY LIST(store_id)

? ? PARTITION pNorth VALUES IN (3,5,6,9,17),

? ? PARTITION pEast VALUES IN (1,2,10,11,19,20),

? ? PARTITION pWest VALUES IN (4,12,13,14,18),

? ? PARTITION pCentral VALUES IN (7,8,15,16)

)；

?

3、HASH分区

?

CREATE TABLE employees (

? ? id INT NOT NULL,

? ? fname VARCHAR(30),

? ? lname VARCHAR(30),

? ? hired DATE NOT NULL DEFAULT '1970-01-01',

? ? separated DATE NOT NULL DEFAULT '9999-12-31',

? ? job_code INT,

? ? store_id INT

)

PARTITION BY HASH(YEAR(hired))

PARTITIONS 4；

?

4、KEY分区

?

5、子分区