Partitioned tables do not support foreign keys. This includes partitioned tables employing the InnoDB storage engine.

Partitioned tables do not support FULLTEXT indexes.

Partitioned tables do not support GEOMETRY columns.

Partitioned tables may use any available MySQL storage engine; however, all of the table's partitions and subpartitions (if there are any of the latter) use the same engine.

A partitioning key must be either an integer column or an expression that resolves to an integer. Currently, NULL values are also permitted; however, this is subject to change.

Subpartitions are limited to HASH or KEY partitioning.