Manually create partitions in the past period

use zabbix;

ALTER TABLE `history` PARTITION BY RANGE(clock)
(
PARTITION p2020_01_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-02 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-03 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-04 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-05 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-06 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-07 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-08 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-09 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-10 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-11 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-12 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-13 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-14 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-15 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-16 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-17 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-18 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-19 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-20 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-21 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-22 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-23 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-24 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-25 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-26 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-27 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-28 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-29 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-30 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_30 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-31 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01_31 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-02 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-03 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-04 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-05 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-06 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-07 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-08 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-09 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-10 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-11 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-12 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-13 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-14 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-15 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-16 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-17 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-18 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-19 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-20 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-21 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-22 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-23 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-24 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-25 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-26 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-27 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-28 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-29 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-02 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-03 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-04 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-05 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-06 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-07 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-08 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-09 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-10 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-11 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-12 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-13 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-14 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-15 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-16 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-17 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-18 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-19 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-20 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-21 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-22 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-23 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-24 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-25 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-26 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-27 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-28 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-29 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-30 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_30 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-31 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03_31 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-01 00:00:00")) ENGINE=InnoDB
);
show create table history\G


ALTER TABLE `trends` PARTITION BY RANGE(clock)
(
PARTITION p2018_01 VALUES LESS THAN (UNIX_TIMESTAMP("2018-02-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_02 VALUES LESS THAN (UNIX_TIMESTAMP("2018-03-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_03 VALUES LESS THAN (UNIX_TIMESTAMP("2018-04-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_04 VALUES LESS THAN (UNIX_TIMESTAMP("2018-05-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_05 VALUES LESS THAN (UNIX_TIMESTAMP("2018-06-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_06 VALUES LESS THAN (UNIX_TIMESTAMP("2018-07-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_07 VALUES LESS THAN (UNIX_TIMESTAMP("2018-08-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_08 VALUES LESS THAN (UNIX_TIMESTAMP("2018-09-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_09 VALUES LESS THAN (UNIX_TIMESTAMP("2018-10-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_10 VALUES LESS THAN (UNIX_TIMESTAMP("2018-11-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_11 VALUES LESS THAN (UNIX_TIMESTAMP("2018-12-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2018_12 VALUES LESS THAN (UNIX_TIMESTAMP("2019-01-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_01 VALUES LESS THAN (UNIX_TIMESTAMP("2019-02-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_02 VALUES LESS THAN (UNIX_TIMESTAMP("2019-03-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_03 VALUES LESS THAN (UNIX_TIMESTAMP("2019-04-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_04 VALUES LESS THAN (UNIX_TIMESTAMP("2019-05-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_05 VALUES LESS THAN (UNIX_TIMESTAMP("2019-06-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_06 VALUES LESS THAN (UNIX_TIMESTAMP("2019-07-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_07 VALUES LESS THAN (UNIX_TIMESTAMP("2019-08-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_08 VALUES LESS THAN (UNIX_TIMESTAMP("2019-09-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_09 VALUES LESS THAN (UNIX_TIMESTAMP("2019-10-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_10 VALUES LESS THAN (UNIX_TIMESTAMP("2019-11-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_11 VALUES LESS THAN (UNIX_TIMESTAMP("2019-12-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2019_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-01-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-02-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-03-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-08-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-09-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-10-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-11-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-12-01 00:00:00")) ENGINE=InnoDB,
PARTITION p2020_12 VALUES LESS THAN (UNIX_TIMESTAMP("2021-01-01 00:00:00")) ENGINE=InnoDB
);
show create table trends\G


exit