amegonの雑なブログ

日常的なものから技術的なものまでメモの雑記

Zabbix のパーティショニングを RANGE で設定

技術メモ

Zabbix 4.0.x で動作確認。

手順

Zabbix をインストールする
以下の文字列をファイルに書いて、シェルで以下のコマンドを実行。

mysql -u [ユーザ名] -p zabbix < '以下のSQL文群を保存したファイル名'

SQL文群

※ パーティションは月単位。RANGEを変える場合は適当にお願いします。

# プライマリキーの作成
# history
DROP INDEX `history_1` ON `history`;
ALTER TABLE `history` ADD PRIMARY KEY (`itemid`, `clock`, `ns`);
# history_uint
DROP INDEX `history_uint_1` ON `history_uint`;
ALTER TABLE `history_uint` ADD PRIMARY KEY (`itemid`, `clock`, `ns`);
# history_str
ALTER TABLE `history_str` ADD PRIMARY KEY (`itemid`, `clock`, `ns`);
# history_text
ALTER TABLE `history_text` ADD PRIMARY KEY (`itemid`, `clock`, `ns`);
# history_log
ALTER TABLE `history_log` ADD PRIMARY KEY (`itemid`, `clock`, `ns`);

# パーティションの作成
ALTER TABLE `history` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);

ALTER TABLE `history_uint` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);

ALTER TABLE `history_str` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);

ALTER TABLE `history_text` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);

ALTER TABLE `history_log` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);

ALTER TABLE `trends` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);

ALTER TABLE `trends_uint` PARTITION BY RANGE (clock) (
PARTITION p2021_06 VALUES LESS THAN (UNIX_TIMESTAMP("2021-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_07 VALUES LESS THAN (UNIX_TIMESTAMP("2021-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_08 VALUES LESS THAN (UNIX_TIMESTAMP("2021-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_09 VALUES LESS THAN (UNIX_TIMESTAMP("2021-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_10 VALUES LESS THAN (UNIX_TIMESTAMP("2021-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_11 VALUES LESS THAN (UNIX_TIMESTAMP("2021-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2021_12 VALUES LESS THAN (UNIX_TIMESTAMP("2022-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_01 VALUES LESS THAN (UNIX_TIMESTAMP("2022-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_02 VALUES LESS THAN (UNIX_TIMESTAMP("2022-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_03 VALUES LESS THAN (UNIX_TIMESTAMP("2022-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_04 VALUES LESS THAN (UNIX_TIMESTAMP("2022-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_05 VALUES LESS THAN (UNIX_TIMESTAMP("2022-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_06 VALUES LESS THAN (UNIX_TIMESTAMP("2022-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_07 VALUES LESS THAN (UNIX_TIMESTAMP("2022-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_08 VALUES LESS THAN (UNIX_TIMESTAMP("2022-09-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_09 VALUES LESS THAN (UNIX_TIMESTAMP("2022-10-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_10 VALUES LESS THAN (UNIX_TIMESTAMP("2022-11-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_11 VALUES LESS THAN (UNIX_TIMESTAMP("2022-12-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2022_12 VALUES LESS THAN (UNIX_TIMESTAMP("2023-01-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_01 VALUES LESS THAN (UNIX_TIMESTAMP("2023-02-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_02 VALUES LESS THAN (UNIX_TIMESTAMP("2023-03-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_03 VALUES LESS THAN (UNIX_TIMESTAMP("2023-04-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_04 VALUES LESS THAN (UNIX_TIMESTAMP("2023-05-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_05 VALUES LESS THAN (UNIX_TIMESTAMP("2023-06-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_06 VALUES LESS THAN (UNIX_TIMESTAMP("2023-07-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_07 VALUES LESS THAN (UNIX_TIMESTAMP("2023-08-01 00:00:00")) ENGINE = InnoDB,
PARTITION p2023_08 VALUES LESS THAN (UNIX_TIMESTAMP("2023-09-01 00:00:00")) ENGINE = InnoDB
);