mysql索引会自动维护_MYSQL-- 每半月一个分区，自动维护

KEY `idx_terminal_id`

(`terminal_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

PARTITION BY RANGE(TO_DAYS (createtime))

(

PARTITION p20101115 VALUES LESS THAN (TO_DAYS('2010-11-15')),

PARTITION p20101130 VALUES LESS THAN (TO_DAYS('2010-11-30')),

PARTITION p20101215 VALUES LESS THAN (TO_DAYS('2010-12-15')),

PARTITION p20101231 VALUES LESS THAN (TO_DAYS('2010-12-31')),

PARTITION p20110115 VALUES LESS THAN (TO_DAYS('2011-01-15')),

PARTITION p20110131 VALUES LESS THAN (TO_DAYS('2011-01-31')),

PARTITION p20110215 VALUES LESS THAN (TO_DAYS('2011-02-15')),

PARTITION p20110228 VALUES LESS THAN (TO_DAYS('2011-02-28')),

PARTITION p20110315 VALUES LESS THAN (TO_DAYS('2011-03-15')),

PARTITION p20110331 VALUES LESS THAN (TO_DAYS('2011-03-31')),

PARTITION p20110415 VALUES LESS THAN (TO_DAYS('2011-04-15')),

PARTITION p20110430 VALUES LESS THAN (TO_DAYS('2011-04-30'))

);