若MySQL原表已有分区,且设置了 LESS THAN MAXVALUE分区,若想添加新分区又不丢失数据,则需要重新分区。
例如:
Alter table `your_table` partition by RANGE(YEAR(login_time))(
partition p1 values less than (2014),
partition p2 values less than (2015),
partition p3 values less than (2016),
partition p4 values less than (2019),
partition p5 values less than (MAXVALUE)
);