Re: Partition Management in MySQL 5.1

[Mikael Ronström]

Hi,

Steven Roussey wrote:
> One thing I don't really care about, but am
> curious on, is why this format:
>
> ALTER TABLE t1 OPTIMIZE PARTITION (x0, x1);
>
> Rather than this:
>
> OPTIMIZE TABLE t1 PARTITION (x0, x1);
>

Well mostly because ALTER TABLE was used for all other PARTITION stuff and
it was very straightforward to integrate it in the parser. So no other stronger
argument other than that it was extremely easy to add those after adding all
the other ALTER TABLE XXX PARTITION commands.

Rgrds Mikael

> etc.?

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com