MySQL: Particionamento de banco Zabbix

Nada de mais por aqui pessoal.
Este é o particionamento (uso MySQL 8.0.19) que fiz da tabela history_uint, que ajudou muito em vários SQLs do Zabbix, e em manutenções do banco como OPTIMIZE.
O particionamento por mês não ficou tão bom, teve que ser por dia mesmo.

Falta ainda colocar uma automação para adição e remoção de partições, que espero fazer em breve.

ALTER TABLE `history_uint` PARTITION BY RANGE (clock)
(
PARTITION p2015 VALUES LESS THAN (UNIX_TIMESTAMP("2016-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2016 VALUES LESS THAN (UNIX_TIMESTAMP("2017-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2017 VALUES LESS THAN (UNIX_TIMESTAMP("2018-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2018 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_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_31 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,
PARTITION p2020_04_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-04-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_04_30 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_30 VALUES LESS THAN (UNIX_TIMESTAMP("2020-05-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_05_31 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-06-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_06_31 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_01 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-02 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_02 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-03 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_03 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-04 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_04 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-05 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_05 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-06 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_06 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-07 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_07 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-08 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_08 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-09 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_09 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-10 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_10 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-11 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_11 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-12 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_12 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-13 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_13 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-14 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_14 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-15 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_15 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-16 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_16 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-17 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_17 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-18 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_18 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-19 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_19 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-20 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_20 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-21 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_21 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-22 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_22 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-23 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_23 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-24 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_24 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-25 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_25 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-26 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_26 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-27 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_27 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-28 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_28 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-29 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_29 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-30 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_30 VALUES LESS THAN (UNIX_TIMESTAMP("2020-07-31 00:00:00")) ENGINE = InnoDB,
PARTITION p2020_07_31 VALUES LESS THAN (UNIX_TIMESTAMP("2020-08-01 00:00:00")) ENGINE = InnoDB);

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.