パーティションテーブル 1年に1回年末に必ず翌年の設定をしてください
■rocaket-la
result_datas
ALTER TABLE result_datas ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
result_error_datas
ALTER TABLE result_error_datas ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
unsubscribe_datas
ALTER TABLE unsubscribe_datas ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
■rocaket-api
click_records
ALTER TABLE click_records ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
click_records_test
ALTER TABLE click_records_test ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
result_records
ALTER TABLE result_records ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
result_records_test
ALTER TABLE result_records_test ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
unsubscribe_records
ALTER TABLE unsubscribe_records ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );
unsubscribe_records_test
ALTER TABLE unsubscribe_records_test ADD PARTITION ( PARTITION p202601 VALUES LESS THAN (202602) ENGINE = InnoDB, PARTITION p202602 VALUES LESS THAN (202603) ENGINE = InnoDB, PARTITION p202603 VALUES LESS THAN (202604) ENGINE = InnoDB, PARTITION p202604 VALUES LESS THAN (202605) ENGINE = InnoDB, PARTITION p202605 VALUES LESS THAN (202606) ENGINE = InnoDB, PARTITION p202606 VALUES LESS THAN (202607) ENGINE = InnoDB, PARTITION p202607 VALUES LESS THAN (202608) ENGINE = InnoDB, PARTITION p202608 VALUES LESS THAN (202609) ENGINE = InnoDB, PARTITION p202609 VALUES LESS THAN (202610) ENGINE = InnoDB, PARTITION p202610 VALUES LESS THAN (202611) ENGINE = InnoDB, PARTITION p202611 VALUES LESS THAN (202612) ENGINE = InnoDB, PARTITION p202612 VALUES LESS THAN (202701) ENGINE = InnoDB );