테이블 파티셔닝

1. CREATE TABLE

CREATE TABLE `data_table` (     `idnr` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'idnr',     `send_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,     PRIMARY KEY (`idnr`, `send_time`), ) COLLATE='utf8_general_ci' ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (YEAR(`send_time`)*100+MONTH(`send_time`)) (     PARTITION p201611 VALUES LESS THAN (201611) ENGINE = InnoDB,     PARTITION p201612 VALUES LESS THAN (201612) ENGINE = InnoDB );

2. ALTER TABLE ADD PARTITION

ALTER TABLE data_table ADD PARTITION(PARTITION p201701 VALUES LESS THAN (201701));

3. ALTER TABLE DROP PARTITION

ALTER TABLE data_table DROP PARTITION p201611;

4. 파티션 확인

EXPLAIN PARTITIONS SELECT TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME =  'data_table ';