Re: Add new partition for Range by date

[Rick James]

Approximately...
ALTER TABLE idea_partition
REORGANIZE PARTITION (rxMORES)
INTO
rx201210 VALUES LESS THAN( TO_DAYS('2012-10-01 00:00:00') ),
rxMORES VALUES LESS THAN (MAXVALUE) );

Suggest you think about ways to shrink the fields:
> `status` varchar(45) NOT NULL,
Is that a boolean value? Perhaps a 1-byte ENUM would work. It would be a lot smaller.
That would shrink the INDEX, too.