4.0.3支持动态增加分区。
– 添加分区
ALTER TABLE sms_sendlog
ADD PARTITION (
PARTITION p20201101 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-01 00:00:00’) ),
PARTITION p20201102 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-02 00:00:00’) ),
PARTITION p20201103 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-03 00:00:00’) ),
PARTITION p20201104 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-04 00:00:00’) ),
PARTITION p20201105 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-05 00:00:00’) ),
PARTITION p20201106 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-06 00:00:00’) ),
PARTITION p20201107 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-07 00:00:00’) ),
PARTITION p20201108 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-08 00:00:00’) ),
PARTITION p20201109 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-09 00:00:00’) ),
PARTITION p20201110 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-10 00:00:00’) ),
PARTITION p20201111 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-11 00:00:00’) ),
PARTITION p20201112 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-12 00:00:00’) ),
PARTITION p20201113 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-13 00:00:00’) ),
PARTITION p20201114 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-14 00:00:00’) ),
PARTITION p20201115 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-15 00:00:00’) ),
PARTITION p20201116 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-16 00:00:00’) ),
PARTITION p20201117 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-17 00:00:00’) ),
PARTITION p20201118 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-18 00:00:00’) ),
PARTITION p20201119 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-19 00:00:00’) ),
PARTITION p20201120 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-20 00:00:00’) ),
PARTITION p20201121 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-21 00:00:00’) ),
PARTITION p20201122 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-22 00:00:00’) ),
PARTITION p20201123 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-23 00:00:00’) ),
PARTITION p20201124 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-24 00:00:00’) ),
PARTITION p20201125 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-25 00:00:00’) ),
PARTITION p20201126 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-26 00:00:00’) ),
PARTITION p20201127 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-27 00:00:00’) ),
PARTITION p20201128 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-28 00:00:00’) ),
PARTITION p20201129 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-29 00:00:00’) ),
PARTITION p20201130 VALUES LESS THAN ( UNIX_TIMESTAMP(‘2020-11-30 00:00:00’) )
);
线上可行