MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Pre-General Availability Draft: 2017-07-17
In MySQL 8.0, partitioning support is not actually
provided by the MySQL Server, but rather by a table storage
engine's own or native partitioning handler. In MySQL
8.0, only the InnoDB
storage engine provides a native partitioning handler. This
means that partitioned tables cannot be created using any other
storage engine.
Note
MySQL Cluster's NDB storage engine
also provides native partitioning support, but is not
currently supported in MySQL 8.0.
ALTER
TABLE ... OPTIMIZE PARTITION does not work correctly
with partitioned tables that use InnoDB. Use
ALTER TABLE ... REBUILD PARTITION and
ALTER TABLE ... ANALYZE PARTITION, instead,
for such tables. For more information, see
Section 13.1.7.1, “ALTER TABLE Partition Operations”.
Upgrading partitioned tables.
When performing an upgrade, tables which are partitioned by
KEY must be dumped and reloaded.
Partitioned tables using storage engines other than
InnoDB cannot be upgraded from MySQL 5.7 or
earlier to MySQL 8.0 or later; you must either drop the
partitioning from such tables with ALTER TABLE ...
REMOVE PARTITIONING or convert them to
InnoDB using ALTER TABLE ...
ENGINE=INNODB prior to the upgrade.
For information about converting MyISAM
tables to InnoDB, see
Section 15.8.1.4, “Converting Tables from MyISAM to InnoDB”.