mysql ---分区管理与维护

mysql 分区管理
为没有分区的表创建分区
alter table user_1 partition by range(age)(
partition age_1 values less than (20),
partition age_2 values less than (30)
);

2:删除某个分区的数据

alter table user_1 drop partition age_2;

3:为分区表添加一个分区

ALTER TABLE user_1 ADD PARTITION (PARTITION age_3 VALUES LESS THAN (30));

ALTER TABLE user_1 ADD PARTITION (PARTITION age_max VALUES LESS THAN maxvalue );

ALTER TABLE user_1 ADD PARTITION (PARTITION age_4 VALUES LESS THAN (40));

4.将分区表的第一个分区分为两个新的分区
ALTER TABLE user_1
REORGANIZE PARTITION age_1 INTO (
PARTITION age11 VALUES LESS THAN (15),
PARTITION age12 VALUES LESS THAN (20)
);
将分区表的第二个分区分为两个新的分区
ALTER TABLE user_1
REORGANIZE PARTITION age_3 INTO (
PARTITION age21 VALUES LESS THAN (25),
PARTITION age22 VALUES LESS THAN (30)
);

5:也可以将两个分区合并为一个分区,也可以理解为重新组织分区

ALTER TABLE user_1 REORGANIZE PARTITION age21,age2