Re: reorganize syntax / procedure

[Rick James]

> mysql> ALTER TABLE ap_log REORGANIZE PARTITION p12 INTO (
PARTITION p12t VALUES LESS THAN (1333252800) ENGINE = InnoDB);

* No, you want to recreate the MAXVALUE partition again.
* Unless you have an old version of MySQL, you can recreate p12 from p12

I recommend
ALTER TABLE ap_log REORGANIZE PARTITION p12 INTO (
PARTITION p12 VALUES LESS THAN (1333252800),
PARTITION future VALUES LESS THAN MAXVALUE
);

Next time, REORGAINZE future INTO p13 and future.
Etc.

As for SUBPARTITIONs, I don't know. I have never found a use for them. What queries benefit from partitioning?