Re: Why the limit that every partition must contain the same number of subpartitions ?

[Matthias Leich]

Mikael and Sergey,

thank you for your fast response and explaining why this limit exists.

So the reasons are around development capacity + planned release dates and
not, that partitioning schemes with different number of subpartitions are
valuated as somehow bad.

I think that, if some requirements are fulfilled, the existing partitioning
features allow to get some significant benefits compared to non partitioned
tables.
I assume that the removal of the described limit will be useful for only a small
number of users and the performance increase will be not dramatic.
So this should better wait till the more promising features are implemented.

Regards,

Matthias

---

Matthias Leich, Software Developer
MySQL AB, www.mysql.com